How to Group Values in Excel
- Click any cell that has a value you want to group by.
- Click the Analyze tab on the ribbon.
- Click the Group Field button. You can also right-click a cell and select Group from the menu. ...
- Specify how you want to group your PivotTable. ...
- Click OK.
Can you group by in Excel?
Group a column by using an aggregate function
For more information see Create, edit, and load a query in Excel. Select Home > Group by. In the Group by dialog box, select Advanced to select more than one column to group by. To add another column, select Add Grouping.
How do I group values in a column?
Select the columns you want to group, or at least one cell in each column. On the Data tab, in the Outline group, click the Group button. Or use the Shift + Alt + Right Arrow shortcut.