Let's say you only wanna select the first column. Cannot, it says 'NO_COLUMN: A'.

=query({O2:P4;O8:P9},"select A")

enter image description here enter image description here

It is easy to select ALL columns.

=query({O2:P4;O8:P9},"select *")

enter image description here

1 Answer

use:

=QUERY({O2:P4;O8:P9}, "select Col1")

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

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