Forum Discussion

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
8 years ago

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,...
Need Help
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
8 years ago

vanessafvg

 

Hi, sorry for my delay.  Looking the complexity of your template / data structure maybe you'll need some Code directly in Advance Editor.   @

 

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
8 years ago

Hi vanessafvg,

please post representative sample data of before and after.

Thanks and cheers, Imke

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    8 years ago

    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.

     

     

  • ImkeF's avatar
    ImkeF
    Icon for Community Champion rankCommunity Champion
    8 years ago

    After is important, because it is not clear to me from the screenshots you showed, which item belongs to wich header/category. 

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    8 years ago

    ImkeF ah i see what you saying, the expected result,  yes makes absolute sense.