Hi, and welcome to the forum.

Working with the layout in your example, copy the following into Cell H6, and then copy across how ever many different roles you have

and down how ever many (unique) performers there are. Your list of unique performers would be Col G (starting at G6). The formula currently

allows for up to 1000 performer names with their (single or multiple) roles in Cols A and B (starting at A6).

If you reposition the formula table, always place this formula in the top left data location and then copy across and down. Also, you will need to keep cols A and B sorted so that the records for one performer are

on adjacent rows (as now).

=IF(COUNTIF($A$6:$A$1005,$G6)>COLUMN(A$1)-1,INDEX($B$6:$B$1005,MATCH($G6,$A$6:$A$1005,0)+COLUMN(A$1)-1),"")

Good luck,

Hercules