Google Sheets: How to Create Pivot Table from Multiple Sheets

The following step-by-step example shows how to create a pivot table from multiple sheets in Google Sheets.

Step 1: Enter the Data

Suppose we have a spreadsheet with two sheets titled week1 and week2:



Suppose we would like to create a pivot table using data from both sheets.

Step 2: Consolidate Data into One Sheet

Before we can create a pivot table using both sheets, we must consolidate all of the data into one sheet.

We can use the following QUERY formula to do so:


Here’s how to use this formula in practice:

Notice that the data from the week1 and week2 sheets are now consolidated into one sheet.

Step 3: Create the Pivot Table

To create the pivot table, we’ll highlight the values in the range A1:C21, then click the Insert tab and then click Pivot table.

We can then create the following pivot table:

The final pivot table includes data from both the week1 and week2 sheets.

Additional Resources

The following tutorials explain how to perform other common operations in Google Sheets:

Google Sheets: How to Sort a Pivot Table
Google Sheets: How to Add Calculated Field in Pivot Table
Google Sheets: Display Percentage of Total in Pivot Table

Featured Posts

One Reply to “Google Sheets: How to Create Pivot Table from Multiple Sheets”

  1. When I run this query, it creates a new set of columns for each sheet. Not sure what the workaround is for that.

Leave a Reply

Your email address will not be published. Required fields are marked *