Duplicate Entries Different Columns

Occasional Visitor


I have a very large spreadsheet showing details for each article a patron requests (Journal Title/Date/Patron etc). I want to create a chart that shows how many times each journal is requested per year. 
I'm assuming I do this in a pivot chart, but I have no idea how to show that information properly!

1 Reply

I think you can do it easily if you convert your data into a dynamic table. Can you post a pic with part of your spreadsheet so I can try to better understand what you want to do?

Related Conversations
Duplicate Favorites/Bookmarks
HotCakeX in Discussions on
0 Replies
Add Feature Duplicate Video
GoceR in Microsoft Stream Forum on
2 Replies
Favorites duplicated again in latest Canary update
davequail in Discussions on
0 Replies
Taking values from certain rows based on data input
Drakerla in Excel on
5 Replies