You are welcome and thanks
Pivot Table looks like Magic Wand but it is not
If you want to play with PowerQuery, add table to Data Model, then create new columns with Calculated Fields/Calculated Columns (divide Name column to the single names), transpose table and create PivotTable from new transposed table. (theory)
Bookmarks