S
S
serw_802020-06-04 06:26:03
Google Sheets
serw_80, 2020-06-04 06:26:03

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.5ed869b4a8f7a473572150.jpeg5ed869c3027b4371641253.jpeg

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Ivanov, 2020-06-04
@serw_80

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 question

Ask a Question

731 491 924 answers to any question