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 you rock will give that a go
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
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
expected result would be to have all fields assigned their own columns with their values if there is on and null if there isn't
as you could see with the work details, the value isn't always directly below the field name
does that make sense Vvelarde
thank you again
