Unstructured Table - Take Name from Row and Put on new column and individual Rows

[wherdzik]

Hi All, This seems pretty challenging and not sure if its doable but I know this is the place to bring up this issue. 

I am not sure I can change the source data so this is what I have to work with.  I have a file that I pull from a vendor which has 11 columns indicating schedule details.  Each section is for a specific person.  I would like to come up with some sort of a process that I can paste an updated data pull each month and then have PowerQuery create a new column with the persons name on each row, related to that data set.  So if you open up my sample file the first section is related to Peck, Stevens on line 7.  I would like to add a column with a header name and then have Peck Stevens on each row starting on line 9 until it reaches the next data section which is Dean, James.  This would be repeated until all data set has a name on each row related to their respective section.

I dont know how to attach the PBIX to here otherwise I would add it here so you can play with the actual sample data.

[wherdzik]

Got it to work. Thank you.

[slorin · Accepted solution]

Hi,

Add new column

if Text.Contains([YourColumn],",") then [YourColumn] else null

and fill down

Stéphane