Hi Guys,
Could someone help me out with pivot tables - I have never used them but I think they might be suitable for my situation.
I have some names of listed companies and their majority shareholders. At the moment the data is in a series of tables arranged by company. I would like to create a new table with all the shareholder names in one column and then the company names in one row so I could easily show which shareholders hold stakes in multiple companies and also be able to filter by cap size. I have made a small mock up at the bottom of my spreadsheet attached..... is this possible with pivot table?
Appreciate the help,
Chris
Bookmarks