Forum Discussion
Data Shaping with M question
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.
Vvelarde hi sorry i dont know if you saw the udpate to my post, sorry to be a pain in the butt, any idea you know how to handle the above scenario
Hi, sorry for my delay. Looking the complexity of your template / data structure maybe you'll need some Code directly in Advance Editor. @ImkeF This is a puzzle that maybe you can help to resolve.
Regards