Google Sheets Query ImportRange where Col = Column(NamedRange)

user_9599749 0
Viewed 105
=QUERY( IMPORTRANGE( "https://URL", "Name Of Sheet!1:999" ), "SELECT * WHERE Col" & COLUMN(namedRange) & "'is not null",0 )

This spits out the error of:

Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " <ID> "Col1 "" at line 1, column 16. Was expecting one of: "(" ... "(" ...

I know part of the solution is working with the "&" symbol to join certain blocks of quotes. The biggest challenge is putting the right quotation marks in the right spot.

google-sheets-formula spreadsheet formula google-sheets import
2 Answers

try:

=QUERY({IMPORTRANGE("id", "Name Of Sheet!1:999")}, 
 "where Col"&COLUMN(namedRange)&" is not null", 0)

select * is not needed if you want all columns

https://URL you dont need it either, just put there ID number of the sheet

user_56326290

Assuming the named range is called TEST

"select Col" & COLUMN(TEST) & " where Col" & COLUMN(TEST) & " is not null "

or

"select * where Col" & COLUMN(TEST) & " is not null "

you have omitted WHERE syntax

user_150193800
Related