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


Hi. One option attached

best response confirmed by HarishRathore (New Contributor)


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.


@HarishRathore , you are welcome.


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


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