How to Group Data in a Pivot Table (2026)
Grouping turns raw values into meaningful buckets — dates into months and quarters, numbers into ranges, individual items into custom categories. This guide covers all three grouping types and when to use each.
⚡ Quick Answer
Right-click any row label in the pivot → Group. For dates: pick years, quarters, months. For numbers: enter bin start, end, and size. For text: hold Ctrl to select multiple items first.
Grouping dates
The most common use of grouping.
Method: Group dates by month, quarter, year
Right-click any date in the pivot
Must be a date value (row label), not a value cell.
Select "Group"
Grouping dialog opens.
Tick the grouping levels
Years, Quarters, Months, Days, Hours, Minutes, Seconds. Tick multiple to nest (e.g., Years + Quarters + Months).
Set Starting At and Ending At (optional)
Excel auto-detects. Override to force specific range.
Click OK
Pivot rows regroup with the new date hierarchy.
In Excel 365 and 2019, dragging a date field to Rows automatically nests Years, Quarters, Months. Turn off via File → Options → Data → uncheck "Disable automatic grouping of Date/Time columns" if you prefer manual control.
Ungrouping dates
Right-click a grouped date row → Ungroup. Reverts to individual dates. Useful if you want to use a timeline slicer instead (timelines require ungrouped dates).
Grouping numbers
Method: Bin numeric values into ranges
Move a numeric field to Rows
Not to Values — as a row label. Example: Deal Size.
Right-click any numeric row label → Group
Grouping dialog opens.
Enter Starting At, Ending At, By
Starting At = smallest bin start. Ending At = largest bin end. By = bin size.
Click OK
Values grouped into equal-width bins as row labels.
Example: Group deal sizes into $10K bins
Starting At: 0
Ending At: 100000
By: 10000Result: rows labeled "0-9999", "10000-19999", "20000-29999", etc.
Grouping text (custom categories)
Not automatic — you group by manually selecting items.
Method: Combine text values into a group
Select multiple row labels
Hold Ctrl and click each label to include in the group.
Right-click → Group
Excel creates "Group1" containing the selected items.
Rename the group
Click "Group1" → type a new name → Enter. Also rename the field label if needed.
Example: Combine North America regions
Data has "USA", "Canada", "Mexico" as separate regions. To roll them up:
- Hold Ctrl, click "USA", "Canada", "Mexico"
- Right-click → Group
- Rename "Group1" to "North America"
Pivot now shows "North America" as a group containing the three countries — you can drill down or roll up.
Grouping in the field list
Grouped fields appear as new sub-fields in the Fields pane. For dates grouped by Year/Quarter/Month, you get separate "Year", "Quarter", and "Month" pseudo-fields. Drag them independently — e.g., Year to Rows, Month to Columns.
Common grouping problems
The row label isn't a groupable type. Dates that are actually text can't be grouped. Fix the underlying data (Data → Text to Columns → Date).
If two pivots share a source, grouping in one affects the other. To have independent groupings, base each pivot on a separate copy of the data — or accept that grouping is shared.
Timelines require ungrouped date fields. Choose: grouping for hierarchical drill-down, or timelines for range selection — you can't easily have both on the same field.
Smart grouping suggestions
Deciding whether to group dates by quarter or month, or how to bin numeric values, takes judgment based on your data's shape. Excel Wizard analyzes distribution and suggests groupings — "your date range spans 3 years — quarter grouping fits best" or "your deal sizes cluster around $50K — try $10K bins."
Install Excel Wizard →Frequently asked questions
How do I group dates in a pivot table?
Right-click any date → Group. Tick Years, Quarters, Months, or Days (multiple for nested). In Excel 365, dates auto-group when you add them to Rows.
How do I group numbers into bins?
Right-click a numeric row label → Group. Enter Starting At, Ending At, and By (bin size). Excel bins values into equal-width ranges.
Can I group text values?
Yes. Hold Ctrl and click multiple row labels → right-click → Group. Rename the resulting "Group1" to a meaningful name.
Why can't I group dates in my pivot?
Some source dates are stored as text. Fix: select the source date column → Data → Text to Columns → Delimited → Next → Next → Date → Finish. Now they're real dates and grouping works.