Can i display my data in a pivot table?

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