Forum Discussion
Unstructured Table - Take Name from Row and Put on new column and individual Rows
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.
Hi,
Add new column
if Text.Contains([YourColumn],",") then [YourColumn] else null
and fill down
Stéphane