Group by Text fields in Excel Pivot Tables | MyExcelOnline

Grouping by numerical data or dates is straightforward to do in Pivot Tables. But another cool thing is you can group by text fields too!

For example, we want to create these groupings:

  • West
    • Americas
  • East
    • Asia
  • Central
    • Africa
    • Europe

I will show you how you can do this in a couple of steps in our Pivot Table.

 

Exercise Workbook:

DOWNLOAD EXCEL WORKBOOK


Here is our current Pivot Table setup:

Group by Text fields in Excel Pivot Tables | MyExcelOnline

STEP 1: Let us group Africa and Europe together.

Hold the CTRL key while clicking on both of them. Right-click on any of the 2 values then select Group

Group by Text fields in Excel Pivot Tables | MyExcelOnline

STEP 2: Now we have our grouping by text. Now click on each of the group headers and rename each one of them to: Central, West, East

Group by Text fields in Excel Pivot Tables | MyExcelOnline

We have the updated group names! Notice that the SALES REGION2 was added automatically because of this.

Click on the arrow beside the SALES REGION2 so that we can give this a better name.

Group by Text fields in Excel Pivot Tables | MyExcelOnline

STEP 3: Set the Custom Name to NEW REGIONS. Click OK

Group by Text fields in Excel Pivot Tables | MyExcelOnline

Your groupings are now all set!

group by text fieldd

HELPFUL RESOURCE:

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

Microsoft Excel Training

You can learn more about how to use Excel by viewing our FREE Excel webinar training on FormulasPivot TablesPower Query, and Macros & VBA!

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn