Hi everyone,
I have to analyze the number of published articles by authors, however, pretty much all the articles have several authors, so I do not know how to use a pivot table to analyze that.
Thatīs the example that I have.
Column A (Article) - Column B (Author 1) - Column C (Author 2)
Article 1 - Jose - Maria
Article 2 - Jose - Joao
I wanted a pivot table like this
Author - Number of articles
Jose - 2
Maria - 1
Joao 1
I did not wanted to change the source table (meaning that the source should still be with 3 columns Article, Author 1 and Author 2)
Bookmarks