Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
wherdzik
Helper II
Helper II

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.

wherdzik_0-1701275535663.png

 

1 ACCEPTED SOLUTION
slorin
Super User
Super User

Hi,

Add new column

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

and fill down

 

Stéphane 

View solution in original post

2 REPLIES 2
wherdzik
Helper II
Helper II

Got it to work. Thank you.

slorin
Super User
Super User

Hi,

Add new column

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

and fill down

 

Stéphane 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors
Top Kudoed Authors