Ungrouping rows or columns
- Activate the pivot table.
- Click anywhere in the group label for the rows or columns that you want to ungroup.
- From the menus choose:
Ungrouping automatically deletes the group label.
Ungrouping automatically deletes the group label.