Ungrouping rows or columns

  1. Activate the pivot table.
  2. Click anywhere in the group label for the rows or columns that you want to ungroup.
  3. From the menus choose:

    Edit > Ungroup

Ungrouping automatically deletes the group label.