Can we use 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.
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 →How to Use Google Sheets for Advanced Project Management
Master Google Sheets for project management with these advanced tips. Check our free tutorials, tools, and templates for data management, task flow, and much more.
Read post →Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
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
How to refresh Google Sheets pivot table
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 refresh pivot table on 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 make 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.
Get the answer →How to edit 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 update 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 use calculated field in 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.
Get the answer →Need more than a quick answer?
600+ 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.