Adult cam 18 - Consolidating multiple spreadsheets into one

Pivot Table - The first example works on multiple files, which must have the data in identical structures, and you can read the instructions on my blog.

To see Kirill's pivot table code, you can download the Pivot Workbooks example.

Multiple sheets means multiple tabs in a single file. Now let us see how to combine the above two sheets to a single sheet in the same Google Sheets file, that in the third sheet named “Combined”. If suppose there is one more sheet named “augsheet” in your file, you can include that sheet as below.

As already mentioned above no script or plugin is required to do it. Below is the Query formula to combine the above two sheets’ data into a single sheet. Just put a semi column and add the sheet name with range. Just by using one more query formula in the last sheet named “Consolidate” we can achieve this result.

For example, if your sheet names are "East" and "West", change this line of code: In the code, you can also change the location where the pivot table will be added.

Comments