Pivot Table Grouping

How to Group Values in Excel

Excel Training

Excel Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Pivot Table Grouping

You can group PivotTable data in order to set it apart from additional subsets of data. You can group most items, but dates are a common item to group. For example, you may want to group the information in the PivotTable by days, months, quarters, or years.

Group PivotTable Values

  1. Click any cell that has a value you want to group by.
  2. Click the Analyze tab on the ribbon.
  3. Click the Group Field button.
    Group Values

    You can also right-click a cell and select Group from the menu.

    The Grouping dialog box appears.

  4. Specify how you want to group your PivotTable.

    When grouping date values, the default starting and ending dates are the first and last dates in the PivotTable.

    To group dates by weeks, select Days in the By area of the Grouping dialog box and enter 7 in the Number of days field below the list.

  5. Click OK.
    Group Values

The PivotTable groups together all the data.

Ungroup PivotTable Values

If you decide you want to see the individual values as column headers again, just ungroup them.

  1. Click a cell that contains the value you want to ungroup.
  2. Click the Ungroup button on the Analyze tab.

    You can also right-click a cell and select Ungroup from the menu.

    Group Values

The grouping is removed from the PivotTable.