I am basing a pivot table on a spreadsheet that has a column called Region/Unit. Here are the fields for the column: 1A, 1B, 2A, 2B, 3A, 3B, 3C, 3D, 4A, 4B, 4C, 4D, 5A, 5B.
I want to use region as a field in my pivot table but do not want to have the letter show up, just have Region 1, 2, 3, 4, and 5.
Is there a way to do this or do I need to create a new column just to show the region only?
I want to use region as a field in my pivot table but do not want to have the letter show up, just have Region 1, 2, 3, 4, and 5.
Is there a way to do this or do I need to create a new column just to show the region only?