MajP, that is very helpful! Thank you. Yes, I realised there are problems with the structure, actually wanted the entries all on one row but didn't know how to do that.
From your examples, if I understand correctly, you're merging various column headers into one column. I would then fill that...