0

So I don't know how to explain this completely, but basically, I'm using the query function to consolidate data from multiple sheets into one Master Sheet. The function itself seems to be working fine and all the data from the other sheets ends up on the Master Sheet.

HOWEVER...

Instead of the data being added vertically so that the number of rows increases, the data is being added horizontally. A picture is attached to explain this better. Basically, it's "copying and pasting" the data from the other sheets into the next COLUMN over instead of the next row.

enter image description here

  • Welcome. Add the formula that you are using an its cell address. – Rubén May 19 at 4:00
  • share a copy of your sheet or formula you use – user0 May 19 at 4:04
0

Instead of , in your formula, use ; - this will stack the queries under each other:

={QUERY(Sheet1!A:B); QUERY(Sheet2!A:B)}

Also, you may want to wrap it all in outer QUERY to get rid of the empty rows:

=QUERY({QUERY(Sheet1!A:B); QUERY(Sheet2!A:B)}, "where Col1 is not null", 0)

(for EU locale use \ instead of ;)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.