Is there a way to quickly (without VBS or macros) generate a list of the main rows from the result of a pivot table when changing search parameters?
Currently I have a pivot table and I need the main Row contents (ie CATEGORY1, 2, 3 below) for a given column linked to a table. As the pivot table filters change I want the linked list to change accordingly.
PIVOT TABLE:
CATEGORY1 DATA DATA DATA DATA
DATA DATA DATA DATA
CATEGORY2 DATA DATA DATA DATA
DATA DATA DATA DATA
CATEGORY3 DATA DATA DATA DATA
CATA DATA DATA DATA
DESIRED RESULT:
CATEGORY1
CATEGORY2
CATEGORY3
Maximum number of categories is about 30.
Currently I'm having to copy the column out of the pivot table after every change or update and manually sort, remove duplicates, and copy the categories where they need to go.
Any thoughts?
I know there must be a simple Index/Match combination or something to make it work but I'm not a pro with those combinations.
Any tips on how to make sure I capture everything to the bottom of a shape shifting pivot table as well?
Bookmarks