were going to show you how to group data in Excel 2016 pivot tables.
Don't forget to check out our main channel for more free how-to videos!
Join us on Facebook
Our App
To start, you will first need a pivot table. Go under the Insert Tab and click PivotTable.
Select the area if your cursor wasnt already in the area and click OK.
Drag and drop the fields to their appropriate positions.
To group data, select the data, right-click it and click Group.
You can also change Group settings on dates for example. Right-click the date and click Group.
You will see more options, choose the ones you want and click OK Date: 2023-07-08
