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.