2

I have the same problem which is discussed here, except that I am working with IMPORTRANGE() instead of a direct array reference (e.g., D12:I119). Somehow I need QUERY() to understand its input as an array of strings. But my attempt to addend a null string (&"") to IMPORTRANGE(), as suggested in the link, doesn't work:

QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/...","Sheet1!A3:1000")&"","select Col1, Col2")

How else can I get around this? Unfortunately, I can't change the data on the spreadsheet referenced by IMPORTRANGE().

player0
  • 124,011
  • 12
  • 67
  • 124
Doubt
  • 1,163
  • 2
  • 15
  • 26

1 Answers1

4

use:

=INDEX(QUERY(TO_TEXT(IMPORTRANGE("https://docs.google.com/spreadsheets/d/...", 
 "Sheet1!A3:1000")), 
 "select Col1, Col2", )
player0
  • 124,011
  • 12
  • 67
  • 124