Problem with QUERY and IMPORTRANGE | Google Sheets

1
votes

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")
1
google-sheetsgoogle-sheets-formula
I removed the jQuery tag because it's not a jQuery question – Alon Eitan
"Why this function does not display results for one of the ranges?" There may be mixed data on the specific range. In any case please share a test sheet so you can be easier helped. – marikamitsos

1 Answers

2
votes

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))