Jun 23 2021 06:20 AM
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
Jun 23 2021 07:40 AM
Hi. One option attached
Jun 23 2021 08:44 AM
SolutionAnother option is in attached file, sheet Result
Jun 23 2021 09:58 AM - edited Jun 23 2021 10:05 AM
Thanks a lot @Sergei Baklan.... Got the perfect result.... Thanks a ton again. This is what I had was expecting to get it.
Regards
Jun 23 2021 10:23 AM
@HarishRathore , you are welcome.
Please note, solution requires M-code customization, not everything is done from user interface.
Jun 23 2021 09:16 PM
Sincere apologies for misunderstanding your ambition re. "data model" in your problem description
Jun 23 2021 08:44 AM
Solution