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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors