Skip to content
Related Articles

Related Articles

Improve Article

Group Pivot Table Data in Excel

  • Last Updated : 27 May, 2021

In the Pivot data table, data can be grouped based on Dates, Numbers, and Text values. In case of dates, we can group dates by months or year, months by years, etc. For numbers, we can group numbers in a particular range band together. For text values, we need to group manually otherwise it will throw an error. 

Group dates by month or year:

Follow the below steps to group dates by month or year in Excel:

Step 1: Create a Pivot Table.

Pivot Table

Step 2: Right-Click a value and select a group.

Select group

Step 3: In the dialog box, under by select the time period. 



Select time period

Step 4: Click OK. The Pivot data table is grouped based on Month and Date.

Group Data by text values:

It is not possible to group textual data using the above method in Excel. It will throw an error if we try to do so. So, we have to select data manually which we want to group, and then group it. 

Step 1: Create a Pivot Table.

Step 2: Select the data cells manually you want to group by pressing the ctrl key while selecting.

Step 3: Right Click and select the Group option.



Step 4: The selected values are grouped and are present under Group1.

Step 5: You can rename the group by anything you want. 

Group data by numbers:

Follow the below steps group data by numbers:

Step 1: Create a Pivot Table..

Step 2: Right-click on a cell and select group.

Step 3: In the dialog box, under by select the interval of groups. 

Step 4: Click OK, Pivot table data is grouped in intervals of 5. 

So, these are the steps to group pivot table data.

Attention reader! Don’t stop learning now. If you are an Excel beginner (or an intermediate) and want to learn Excel, Geeksforgeeks brings the perfect course for you to start, Diving Into Excel

My Personal Notes arrow_drop_up
Recommended Articles
Page :