CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
AdOne
AdOne

Reputation: 131

Problem with QUERY and IMPORTRANGE | Google Sheets

Why this function does not display results for one of the ranges? With no QUERY the results are displayed correctly.

QUERY({
IMPORTRANGE("url";"Sheet1!A1:B5");
IMPORTRANGE("url";"Sheet2!A1:B5");
IMPORTRANGE("url";"Sheet3!A1:B5")};
"SELECT Col1, WHERE Col1 IS NOT NULL")

Upvotes: 1

Views: 239

Answers (1)

player0
player0

Reputation: 1

try:

=ARRAYFORMULA(QUERY(TO_TEXT({
 IMPORTRANGE("url"; "Sheet1!A1:B5");
 IMPORTRANGE("url"; "Sheet2!A1:B5");
 IMPORTRANGE("url"; "Sheet3!A1:B5")});
 "select Col1 where Col1 is not null"; 0))

Upvotes: 2

Related Questions