Group or ungroup data in a PivotTable

Grouping data in a PivotTable can help you show a subset of data to analyze.

Group Data
1. Select the items you want to group.

Items
2. In the PivotTable, right-click a value and select Group.

PivotTable

2. Excel will create a grouped category.

Group Data

Grouped

Ungroup Grouped Data

1. Click the grouped field in the PivotTable.

PivotTable

2. Right-click the grouped item and select ungroup.

Ungroup PivotTable

3. Excel will create a ungrouped category.
Ungrouped PivotTable