Forum Discussion
Data Shaping with M question
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.
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
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
ImkeF thanks will put something together tomorrow, not much to show for after to be honest because finding it hard to pull the data vertically and horizontally.
After is important, because it is not clear to me from the screenshots you showed, which item belongs to wich header/category.
ImkeF ah i see what you saying, the expected result, yes makes absolute sense.
