I tried to use Query function and it was functioning well at first. I initially only had 7 columns. However, when I tried to use to my document with up Column AZ, it is not working anymore.

This was the formula I used:

=QUERY({'Trial Data 1'!A2:H;'Trial Data 2'!A2:H;'Trial Data 3'!A2:H},"select * where Col1 is not null",0)

This was the formula for my other doc with up to column AZ that resulted to Parse Error:

=QUERY({'Trial Data 1'!A2:AZ;'Trial Data 2'!A2:AZ;'Trial Data 3'!A2:AZ},"select * where Col1 is not null",0)

Also, is there a way that only the data of selected columns will show? For example, only columns A, B, G, H, J, K, etc. will show?

Thank you.


1 Answer 1


The second formula looks fine, so chances are that you did not actually get a syntax error but an array literal error. The error is most likely caused by one or more of the sheets not actually having that many columns. Insert columns in the sheets so that column AZ exists on all of them.

To refer to columns A, B, G, H, J, K in your query({array expression}, use "select Col1, Col2, Col7, Col8, Col10, Col12 where Col1 is not null".

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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