Different size rows in array literal google sheets

U

user12341234

Guest
I'm trying to do this in Google Sheets

={{1}; {1, 1}}


and get the error In ARRAY_LITERAL, an Array Literal was missing values for one or more rows.

My ultimate goal is to do something like this:

"title A"
IMPORTRANGE("spreadsheet A", A:Z)...
"title B"
IMPORTRANGE("spreadsheet B", A:Z)...
"title C"
IMPORTRANGE("spreadsheet C", A:Z)...
etc...


Preferably the import range would ignore empty A rows as well. Each spreadsheet has different amount of columns and rows and they all change every once in a while.

Continue reading...
 
Top