Answer the question
In order to leave comments, you need to log in
How to make a pivot table in Google Sheets from multiple sources?
Good day!
Dear professionals, tell me, please answer the question:
there is a file in Google spreadsheets. The file contains 4 sheets with tables of the same format, but with a different (changes once a week) number of lines.
It is necessary that a table is formed on the summary sheet from all tables on the sheets. That is, the rows of tables (without a header) rose one above the other.
I tried to solve it through importrange - it did not work, because if a new row has appeared in one of the tables, then it does not allow the rest to correctly appear in the summary.
Answer the question
In order to leave comments, you need to log in
Use range concatenation
={Лист1!A2:C10;Лист2!A2:C10;Лист3!A2:C10}
For your case, allow for empty strings
=FILTER({'1'!A:H;'2'!A:H;'3'!A:H;'4'!A:H};{'1'!A:A;'2'!A:A;'3'!A:A;'4'!A:A}<>"")
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question