Forum Discussion

Icon for Community Champion rank

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

Icon for Community Champion rank

Community Champion

8 years ago

Hi, please try following the steps of the image:

Regards

Victor

Lima - Peru

jcarville
Skilled Sharer
8 years ago
Vvelarde, nice one! I was having a go at this myself and was waiting for a solution.
vanessafvg
Community Champion
8 years ago
Vvelarde you rock will give that a go
- 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
  - Vvelarde
    Community Champion
    8 years ago
    vanessafvg
    
    Ohh, well I will try. in your scenario what is the expected result.
    
    With 2 cases and 2 results will be very helpful to me and others.
    
    Victor
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