Originally Posted by
6StringJazzer
Pivot tables are for doing numeric analysis on data, not for organizing text. There are two options that I can think of (which means there are more options that I cannot think of).
One is to move the Location underneath the Company, instead of making it a column. In your real data, can a single company have more than one location? I expanded your data and your pivot table to illustrate.
Another is to use formulas instead of a pivot table. That is just a bit trickier so I don't want to spend the time on it if the reorganized pivot solves the problem.
Bookmarks