This article will show you how to Group Pivot Tabe Items in Excel.
| Join the channel Telegram of the AnonyViet 👉 Link 👈 |
I will use the pivot table below as an example for you. You can read this article to learn how to create a pivot table.
How to Group Pivot Table Items
Product Group
1. In the pivot table, select Apple and Banana.
2. Right-click and select Group
3. In the pivot table, select Beans, Broccoli, Carrots, Mango and Orange.
4. Right-click and select Group
Result
Group day
1. Click any cell inside the column with the date.
2. Right-click and select Group
3. Select Quarters and press OK
Result
In addition, you can also view many other excel articles here.
