Hi all, I'm hoping someone can help with my problem.

I need a formula which can concatenate the values in a row along with its corresponding column header and sub header descriptions, I've been trying to work with Offset, Lookup and Concatenate but am struggling to get a solution.


Formula_example.PNG

Many thanks for your help in advance!