What is a pivot table Google Sheets
Select your data table, then Insert → Pivot table. Choose New sheet or Existing sheet. Drag fields into Rows, Columns, Values, and Filters in the pivot editor. Refresh by editing the source range; keep headers clean and one row per record.
Steps
-
1
Select the source data including headers.
-
2
Insert → Pivot table.
-
3
Place fields into Rows / Columns / Values.
-
4
Adjust value summarize-by (SUM, COUNTA, etc.).
Related blog posts
Written guides that go deeper on this question.
20 Google Sheets Tips for Bloggers
Through the use of computational tools, like AI and automation functions, you can gain insight from data that was previously too time consuming to extract.
Read post →20 Google Sheet Tips for Business Analysts
Learning Google Sheets empowers Business Analysts to efficiently analyze data, create insightful visualizations, collaborate with stakeholders, and streamline their data analysis workflows. It's a valuable tool for data-driven decision-making and problem-solving in a business context.
Read post →3 Google Sheet Tips for Administrative Professionals
Learning more skills in Google Sheets empowers administrative professionals to manage data efficiently, make data-driven decisions, collaborate effectively, and improve overall productivity.
Read post →Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
No exact channel match cached for “What is a pivot table Google Sheets” yet. Search Better Sheets on YouTube.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
filters in Google Sheets
Filtering hides rows that do not match criteria without deleting data. The filter toolbar on a header row is the fast...
Open →FILTER
FILTER returns only the rows from a range that meet one or more conditions. Conditions are boolean arrays the same he...
Open →Pivot table
A pivot table summarizes a large table without writing SUMIFS for every combination. Drag fields into rows, columns, ...
Open →CLEAN()
Google Sheets CLEAN() function guide
Open →COLUMNS()
Google Sheets COLUMNS() function guide
Open →COUNTA()
Google Sheets COUNTA() function guide
Open →ROWS()
Google Sheets ROWS() function guide
Open →SUM()
Google Sheets SUM() function guide
Open →Related questions
What is a pivot table in Google Sheets
Select your data table, then Insert → Pivot table. Choose New sheet or Existing sheet. Drag fields into Rows, Columns, Values, and Filters in the pivot editor. Refresh by editing the source range; keep headers clean and one row per record.
Get the answer →How to do pivot table in Google Sheets
Select your data table, then Insert → Pivot table. Choose New sheet or Existing sheet. Drag fields into Rows, Columns, Values, and Filters in the pivot editor. Refresh by editing the source range; keep headers clean and one row per record.
Get the answer →How to do a pivot table in Google Sheets
Select your data table, then Insert → Pivot table. Choose New sheet or Existing sheet. Drag fields into Rows, Columns, Values, and Filters in the pivot editor. Refresh by editing the source range; keep headers clean and one row per record.
Get the answer →What is pivot table in Google Sheets
Select your data table, then Insert → Pivot table. Choose New sheet or Existing sheet. Drag fields into Rows, Columns, Values, and Filters in the pivot editor. Refresh by editing the source range; keep headers clean and one row per record.
Get the answer →Can you do a pivot table in Google Sheets
Select your data table, then Insert → Pivot table. Choose New sheet or Existing sheet. Drag fields into Rows, Columns, Values, and Filters in the pivot editor. Refresh by editing the source range; keep headers clean and one row per record.
Get the answer →How to do pivot tables in Google Sheets
Select your data table, then Insert → Pivot table. Choose New sheet or Existing sheet. Drag fields into Rows, Columns, Values, and Filters in the pivot editor. Refresh by editing the source range; keep headers clean and one row per record.
Get the answer →Need more than a quick answer?
636+ walkthrough videos, unlimited generators, and every template. From $9/month. Practical lessons. Zero fluff.
Need one fix
Watch a free tutorial for the step-by-step version of any answer.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.