2

I would like to merge 2 Google sheets (INPUT #1 & INPUT #2) into 1 sheet (OUTPUT). These 3 sheets are enclosed in the same Google Spreadsheet.

On a daily basis, Sheets INPUT #1 & INPUT #2 are updated by the end of the data series.

OUTPUT should adapt automatically.

Can you help me?

enter image description here

player0
  • 124,011
  • 12
  • 67
  • 124
Henri
  • 1,571
  • 5
  • 23
  • 38

1 Answers1

4
={INPUT1!A1:C1,INPUT2!B1:C1;
 {QUERY({INPUT1!A2:D}, "select Col1,Col2,Col3,' ',Col4 where Col1 is not null label ' '''");
  QUERY({INPUT2!A2:D}, "select Col1,' ','  ',Col2,Col3 where Col1 is not null label ' ''','  '''")}}

0

player0
  • 124,011
  • 12
  • 67
  • 124
  • Sure @player0 here you are: https://docs.google.com/spreadsheets/d/1SXzaGh0a9vwHov16z4clxFubt1UMiL0u3isLpay7fRo/edit?usp=sharing – Henri Mar 11 '19 at 16:19
  • that's a label part where I "name" label to be empty - otherwise, you would have there 2 more rows. you can try to check it out how it looks like when you remove `label ' '''` from a query – player0 Mar 12 '19 at 10:34