Google Sheets: Create Pivot Table from Multiple Sheets

By /

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:

Week1:

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:

=QUERY({week1!A1:C11;week2!A2:C11})

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.

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:

x

Related posts:

  1. Excel: Create Pivot Table from Multiple Sheets
  2. Google Sheets: Create Pivot Table with Unique Counts
  3. Google Sheets: Create Pivot Table with Count of Occurrences
  4. Pandas: Create Pivot Table with Multiple aggfunc
  5. Google Sheets: Remove Grand Total from Pivot Table
  6. Sort a Pivot Table in Google Sheets (With Example)
  7. Excel: Sort Pivot Table by Multiple Columns
  8. Excel: Apply Multiple Filters to Pivot Table at Once
  9. Pandas: Create Pivot Table with Percentages
  10. Excel: Create Pivot Table Based on Filtered Data
Scroll to Top