Multiple spreadsheets imported into one using IMPORTRANGE

Question

I am trying to combine multiple spreadsheets into one master spreadsheet by using IMPORTRANGE. Tried the following:

=QUERY({IMPORTRANGE("187znjFwW25ZNSovWcAv43hjYynmsEJW_MU46BgoACZY","Status!A:BJ");IMPORTRANGE("2v4XB81Io7H70WBgmEu_gZ4233E7qf9l2Nfvlc1AfLuM","Status!A:BJ")},"where Col1 is not null")

or

={IMPORTRANGE("187znjFwW25ZNSovWcAv43hjYynmsEJW_MU46BgoACZY","Status!A:BJ");IMPORTRANGE("2v4XB81Io7H70WBgmEu_gZ4233E7qf9l2Nfvlc1AfLuM","Status!A:BJ")}

and always saw:

In ARRAY_LITERAL, an Array Literal was missing values for one or more rows

I also made to sure to do IMPORTRANGE for each spreadsheet and click on 'allow' - so individually they are being imported but I cannot combine them into one sheet in the new spreadsheet.

Any thoughts?

tried it but i don't think it worked, can you share an example of what you meant ? (to ensure I am putting the right syntax)-- thanks again pnuts! :) — Yura F Kleban
Heya-- thanks again pnuts-- I tried that and it didn't work. The only thing that worked was putting a lot less columns :( — Yura F Kleban

ASE Dev ASE Dev · Accepted Answer · 2018-06-13T21:50:34

Ensure dat the array is define to the actual source, eg. =QUERY({IMPORTRANGE("187znjFwW25ZNSovWcAv43hjYynmsEJW_MU46BgoACZY","Status!A1:BJ1000");IMPORTRANGE("2v4XB81Io7H70WBgmEu_gZ4233E7qf9l2Nfvlc1AfLuM","Status!A1:BJ880")},"where Col1 is not null")

The Array on both import range needs to match exact total rows in the extract sheet.

Multiple spreadsheets imported into one using IMPORTRANGE

1 Answers