Forum Discussion
Combine multiple Google Sheets from Google Drive
Combine 25 google sheets by appending them to one another so they form a single table. That will be your main table. Right click that query of combined sheets and select reference. Filter name column to the desired sheet name and then do the necessary transformations. Repeat the steps, this time in another query, for the other sheet name. So you will have about 26-27 queries using following this approach (25 queries to append + 2 reference queeries for sheets A and B) vs about 50 queries (25 queries each for sheets A and B).
Hi All
I implemented using another way to combine multiple sheets with a Parameter, a Table with URLs of all google sheets and a custom function.
Refer
This allowed me to change paths dynamically and make the reports scalable as well.
Hope it helps
Thanks Danextian
Hi All
I implemented using another way to combine multiple sheets with a Parameter, a Table with URLs of all google sheets and a custom function.
Refer
This allowed me to change paths dynamically and make the reports scalable as well.
Hope it helps
That's another way to put it. Should be a google spreadsheet with spreadsheet urls in it.