I have a column with dozens and dozens of columns in it that I'm querying data from. I'm using something similar to below to do this, but I'm wondering if there is an easier way? For instance, something like "Select B:Z where K = X"
or "Select B through Z where K = X"
or "Select * excluding S where K = X"
?
=QUERY(data!B1:J30000, "Select B, C, D, E, F,.......
Is it possible to select columns based on a 'range' instead of manually entering each column?