Hi I am trying to create a pivot table to show on which year each item on a list appeared.
I have attached a sample data file and on the second tab I manually entered what I am trying to generate from pivot table as my data is larger.
Can't figure out how to organize the pivot table to see the data as in the second tab of the sample file I uploaded.
thanks in advance!
AJ
Bookmarks