Pinterest Pixel

Group by Text fields in Excel Pivot Tables

Bryan
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 workbookGroup-by-Text-fields.xlsx


Here is our current Pivot Table setup:

Group by Text fields in Excel Pivot Tables

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

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

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

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

Group by Text fields in Excel Pivot Tables

Your groupings are now all set!

Group by Text fields in Excel Pivot Tables

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

If you like this Excel tip, please share it



Group by Text fields in Excel Pivot Tables | MyExcelOnline


Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Prepare Data for Excel Pivot Tables

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...