The source data contains three fields: Name, Age, and Group. Only Name and Age are used in the pivot table as shown:

Age is used as a Row field. After Age has been added to the pivot table, it has been grouped as below:

Starting and ending value are automatically entered based on the source data. The “by” is set to 10 years, but can be customized as needed. The pivot table maintains age grouping when fields are added or reconfigured. For example, when the Group field is added as a Column field, the pivot table below is created:



Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.   

Pivot table group by age - 4Pivot table group by age - 62Pivot table group by age - 8