Suppose I have two Google sheets, Doc1 and Doc2, both of which have only one sheet with two lists with the same schema, say two columns Name and Age. The number of entries in the lists is unknown, but if it makes the task easier, we can assume that they have at most 5 entries:
I want to bring the two lists together and display them in a third "Summary" document, one after the other. I can show them using these formulas, in the Summary cells
= IMPORTRANGE ("1cLqgopAWG ...", "Sheet1! A1: B5") = IMPORTRANGE ("1564EXoW-s ...", "Sheet1! A1: B5")
However, this leaves a boring variable number of blank lines between the two:
while I would like to show them one directly above the other, as if (manually copied values here to show what I want):
If I try to use
IMPORTRANGE in two contiguous rows (i.e.
A2), I have a
#REF! error ("The result of the array was not expanded because it would overwrite the data in A2."):
Is it possible to achieve what I want?
(Bonus points to remove the constraint on the maximum number of items.)