Forum Discussion
Data Shaping with M question
I have an excel file that is a template for inputting reports on fault equiment. because its a form the data looks a lot like below, there is a category and then a value in the same role underneath,...
Vvelarde hi sorry i dont know if you saw the udpate to my post, sorry to be a pain in the butt, any idea you know how to handle the above scenario
Hi, sorry for my delay. Looking the complexity of your template / data structure maybe you'll need some Code directly in Advance Editor. @ImkeF This is a puzzle that maybe you can help to resolve.
Regards
ImkeF thanks will put something together tomorrow, not much to show for after to be honest because finding it hard to pull the data vertically and horizontally.
After is important, because it is not clear to me from the screenshots you showed, which item belongs to wich header/category.
ImkeF ah i see what you saying, the expected result, yes makes absolute sense.
