Can you create 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.
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 tutorials
These videos might help you go deeper on this topic.
3 Free Tools to Make Your Google Sheets Better
Created a GPT function in Sheets
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.
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 create 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 create pivot table in google sheet
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 do i create 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 do you create 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 →Can you create 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 →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.