Table like a Pivot

[itsgrady]

I have a table and I would like to set up another table that summarizes the data from the first table. However, I'm having difficulty extracting the unique names from the first table to use in the new table, similar to a pivot table. Unfortunately, I am unable to use the unique formula in a table.

I would greatly appreciate your guidance on how to extract the unique names and incorporate them into the new table.

I tried this formula but it do not pull the unique out of the Owner column.

INDEX(Table1[Owner],MATCH(0,COUNTIF($A$1:A2,Table1[Owner]),0)).

Thank you for your assistance.

 

[alansidman]

Please show us some sample data (8-12 records) and a mocked up solution of what you expect. Use XL2BB and no pictures as they cannot be manipulated.

 

[RoryA]

Why does the second one need to be a table, and why can't you use an actual pivot table?