Forum Discussion
Data Shaping with M question
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
thank you so much, that was really useful i learned a lot, unfortunately once again trying ot protect the content of the data ive understated the requirements;
1) you can get more than one field on the same row so when you combine columns you have up to 4 columns on the same row with lots of gaps between
2) there are hundreds of these templates that need to be combined, so doing a group by on the field name wont work because you wont know which form it came from
i learned a lot from what you posted but struggling with the issues from above
this is an exapmle the actual data below , as i said here are many forms so thats just the first one sucked in by power query.