Instead of showing a long list of items in a pivot table, you can group dates or numbers, and even text, to create a shorter list.
In this example, the units have been grouped by tens, so there are only 5 columns of summarized data, instead of 50.
The starting number for the grouping has been set at 1, and the upper limit has not been set. If higher number are added to the source data, those number would appear in new groupings.
Watch the Grouping Video
To see the steps for grouping numbers, you can watch this short video tutorial.
Download the Sample File
For more information on grouping data in a pivot table, and to download the sample file, please visit my Contextures website: Pivot Table Grouping
_________