Categories
October Surprise 2024

Query function prints headers, but no data – Google Help

Query function prints headers, but no data I am puzzled by the failure of a query function. This instance works perfectly: =Query ( {‘b2′!A1:Q99;’c2’!A2:Q99},”SELECT Col1,Col2,Col3,Col4,Col8,Col9,Col10,Col11 WHERE Col1 != ” ORDER BY Col1 ASC, Col3 ASC”,1) I used this successful instance to write the following into a different spreadsheet: