Fields
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:
Steps
Author
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.
