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

Question

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.

Accepted Answer

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'")
```

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

Solution

Problem