SOLVED

Advanced Data Transformation using Power Query

New Contributor

Hi Team,

 

This is to inform you that I am stuck at one advanced data transformation where I need to transform some unstructured data into data model using Power Query. I am attaching an excel where one sheet is "Problem" statement and another sheet is my "Expected Result".

Early response is highly appreciated.

 

Thanks & Regards

Harish Rathore

5 Replies

@HarishRathore 

Hi. One option attached

best response confirmed by HarishRathore (New Contributor)
Solution

@HarishRathore 

Another option is in attached file, sheet Result

Thanks a lot @Sergei Baklan.... Got the perfect result.... Thanks a ton again. This is what I had was expecting to get it.

Regards

@HarishRathore , you are welcome.

 

Please note, solution requires M-code customization, not everything is done from user interface.

@HarishRathore 

Sincere apologies for misunderstanding your ambition re. "data model" in your problem description