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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.