Forum Discussion

vanessafvg's avatar
vanessafvg
Community 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, and in the same column are many categories with values.   How do you go about shaping this so that the category becomes the colum and the value underneath the value, it would be be easy if it was only one category per column but because there are multiple it is not so simple.  Also how can you grab the line after the category?

 

thanks!

 

 

I have 

Need Help

15 Replies

    • jcarville's avatar
      jcarville
      Skilled Sharer
      8 years ago

      Vvelarde, nice one! I was having a go at this myself and was waiting for a solution.

      • vanessafvg's avatar
        vanessafvg
        Community Champion
        8 years ago

        Vvelarde ah sorry i actual over simlified the requirements, the issue is the issue of the column is spread across multiple columns that may or may not have data in them and may or may not have different fields

         

        for example it looks a bit more like this

         

         

    • mjht07's avatar
      mjht07
      Regular Visitor
      8 years ago

      Vvelarde  how can I slow down you demonstration video so I can follow along with the steps?  I am new to this and it goes too fast for me to absorb