Table of Contents
Creating a pivot table in Google Sheets allows you to summarize and analyze data from multiple sheets in a single table. To do this, first select the data you want to include from each sheet and combine them into one sheet. Then, insert a pivot table by going to the “Data” menu and selecting “Pivot table.” Choose the combined data sheet as the source and select the fields you want to include in the pivot table. You can then customize the table by rearranging the fields, adding filters, and choosing the type of data calculation you want to use. This will provide a clear and organized view of your data, making it easier to analyze and draw insights from.
Google Sheets: 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:
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
Cite this article
stats writer (2024). How can I create a pivot table in Google Sheets using data from multiple sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-create-a-pivot-table-in-google-sheets-using-data-from-multiple-sheets/
stats writer. "How can I create a pivot table in Google Sheets using data from multiple sheets?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-create-a-pivot-table-in-google-sheets-using-data-from-multiple-sheets/.
stats writer. "How can I create a pivot table in Google Sheets using data from multiple sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-create-a-pivot-table-in-google-sheets-using-data-from-multiple-sheets/.
stats writer (2024) 'How can I create a pivot table in Google Sheets using data from multiple sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-create-a-pivot-table-in-google-sheets-using-data-from-multiple-sheets/.
[1] stats writer, "How can I create a pivot table in Google Sheets using data from multiple sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I create a pivot table in Google Sheets using data from multiple sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.