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,...
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.