google-sheetsgoogle-query-language

Is there a way to insert blank columns in output with google sheets query?

Consider the query run from sheet2

=query(Sheet!A7:A, "Select A,B,C where A='Order'")

but I want to put this in columns A,E,F in Sheet2.

I've found the workaround 

=query(Sheet!A7:A, "Select A,X,Y,Z,B,C where A='Order'")

Where XYZ are blank columns from the end of the range. This seems clunky.

So far searches in both the query syntax on Google docs, and google product forums have been unproductive.

Solution

  • Put the empty columns as literals in the query - cannot really be empty though, must contain a space like this

    =query(Sheet!A7:C, "Select A,' ',' ',' ',B,C where A='Order'")