2

I am using a query on import range to pull relevant data from one spreadsheet into another. It was working fine, then all of the sudden it started combining the first 8 rows into one row, but the rest are importing as normal. The columns are spaced correctly, but each column is concatenating the first 8 rows for some reason.

Here is my formula: 

=query(importrange("other_sheet","Sheet1!$A$2:$O"),"Select Col1,Col7,Col2,Col3,Col4")

What can I do to make sure the first 8 rows each return into their own rows from the query?

player0
  • 124,011
  • 12
  • 67
  • 124
aediger2
  • 35
  • 6

1 Answers1

1

try to force it with 0 header rows like:

=QUERY(IMPORTRANGE("other_sheet", "Sheet1!$A$2:$O"), "select Col1,Col7,Col2,Col3,Col4", 0)
player0
  • 124,011
  • 12
  • 67
  • 124
  • That works! Why does that fix it? I am pretty new to the query function, so I want to understand how it works. – aediger2 Nov 14 '19 at 15:50
  • by not including 3rd query parameter, query will auto-assume on its own what to do and sometimes you get such a weird results – player0 Nov 14 '19 at 20:01