Book4.xlsx See attached. Yes, you can do with with a pivot. You just need to create a pivot (preferably turn your datasource into an Excel Table with the Ctrl T shortcut first, so that the pivot always points to the data even if you add new rows), then drag the column with letters into the ROWS field, drag the ones with Names into the ROWS field also, turn off subtotals, and select 'Show in Tabular form' from PivotTable Tools>Design Tab> Report Layout
See attached.
Bookmarks