Query Over Frozen Columns

[David Heup]

Still figuring out the details, but I found a glitch when combining a query and importrange across frozen cells

The formula =query(importrange("https://URL", "Sheet1!C:E")) works just fine, but =query(importrange("https://URL", "Sheet1!C:F")) returns a bunch of data in one cell. In the original sheet, column E is frozen.

The workaround I came up with is to split the query. Just wondering if anyone has a better way.

Dave

[Hassam Saeed]

Hey David,
I wonder why you are using this:

=query(importrange("https://URL", "Sheet1!C:F"))

instead of this:

=importrange("https://URL", "Sheet1!C:F") 

In case, if you are filtering data thats being imported, then please provide other arguments that you are providing to query formula to better understand the problem.

Note: Frozen columns/rows don't have any impact on the formulas.