I've rarely used pivot tables, so hopefully someone else can give more specific advice. I doubt, though, that even a VBA solution could avoid the need for a 'helper' column for the suffixes once it comes to actually generating the pivot table. Of course, if you add the equivalent formula to the data source you're generating the pivot from (yes, all 58,000 rows of it), or use a macro to generate the same output there, you could then generate the pivot table using the suffixes column instead of the labels column.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|