extract player names following text string references

steveccc 

Variant with Power Query is based on idea here https://bondarenkoivan.wordpress.com/2015/04/16/multiple-replacements-of-words-in-power-query/

First, we create table with separators 

and with query add column to which transform separators, like "PG " => "* PG "

With above function we transform source table into

and split column into rows by "* " delimiter

adding index and conditional column we give unique number to each group of names

Filter nulls, remove Index and pivot Lineup.1 on Lineup.2 with rows aggregation. Remove Custom column and load result back to Excel sheet.

That is in the second sheet of the attached file.

If source data is in csv file you may connect it directly instead of data table as here.