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
PhillipB
Frequent Visitor

Transforming uneven data

Hi,

 

I need to be able to change the way this data is displayed.

 

Order noPartQty
1001123456-0118000
1001SSL4461
1001SSJ8875
1002123568-03265
1002SSL4452
1002SWD5848
1002EED8544
1002RTG5683
1003856714-032000
1003SEF5615
1003SSL4466
1004243578-036000
1004EED8548
1004SSL44610
1004RFY89512
1004PLE5596
1004RTG5689
1005143578-03500
1005SEF5612
1006123708-026000
1006SSJ88750
1006PLE55910
1006SWD58412

 

The parts with the ######-## format are the main part and the others under are sub parts but the output should be

 

Order NoPartQtySub1QtySub2QtySub3QtySub4QtySub5Qty
1001123456-0118000SSL4461SSJ8875      
1002123568-03265SSL4452SWD5848EED8544RTG5683  
1003856714-032000SEF5615SSL4466      
1004243578-036000EED8548SSL44610RFY89512PLE5596RTG5689
1005143578-03500SEF5612        
1006123708-026000SSJ88750PLE55910SWD58412    

 

The number of sub parts is not consistent.

1 REPLY 1
BiNavPete
Resolver III
Resolver III

Hi @PhillipB 

Not sure how to manage more than 5 products but check out power query in attached PBIX.

Link Here.

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.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

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.