Need help on Excel from an expert that knows far more than I do. I have a pivot table, but pivot tables cannot display text values as we need. I recall seeing someone who did something similar in the past , but I cannot seem to find anything.
If I recall, formulas were used, but I could not create any that worked for the solution we need.
If this can be done directly in Share point somehow, great, but I can easily refresh the data from a linked .iqy file
Thank a million for looking!