Query all sheets in a Google Spreadsheet to get all data into a single Sheet

0
votes

I have a Google Spreadsheet containing some sheets with data. All sheets have the same amount of columns, and the same "data type".

Link to spreadsheet: https://docs.google.com/spreadsheets/d/1Yif8Cf1g1pPI38YFCffDKQ1tE-08SWPSfRAv-TdWXTw/edit#gid=0

It's the first column in the first sheet (all) that I can’t get to work.

This is what I have now, but it only fetches the first sheet:

=QUERY({mc!A2:E;bwl!A2:E;zg!A2:E},"select *")

The function looks okay?

1
google-sheets

1 Answers

2
votes

if you scroll way down, you'll see that you ARE actually getting all the other sheets, you're just also getting all the empty rows. You just need to add "where Col1 is not null" to your query string like this:

=QUERY({mc!A2:E;bwl!A2:E;zg!A2:E},"select * where Col1 is not null")

That will pull out the blank rows.