Stacking an array of columns of data with a header

Hello,

I have an array of columns of varying length. Each column has a header. In order to facilitate analysing the data I need to stack up those columns so that the header appears in column 1 and the data under the header appears in column 2. The header needs to repeat on every line. Here's what I mean:

I have:
Result A Result B Result C
753 7354 5529
1071 2415
3054
6832

And I need to convert it to:
Result A 753
Result B 7354
Result B 1071
Result B 3054
Result B 6832
Result C 5529
Result C 2415

In my real example I have 160+ columns and up to 466 rows so an automated solution would be really handy!
thanks for your ideas
Mx

Hi,

See the file. Orange cells are data, green cells are helper cell and yellow is output with formula.

Brilliant!
I do not understand how it works, but it does the job,

For those of you who looked but didn't download the file, misrasomendra used some clever INDEX and MATCH functions in an array formula

thank you very much :-)

Hi,

Thanks for the feedback and kind words. If your problem is solved you can mark the thread as SOLVED and if you feel the solution had helped you can donate some reps points by clicking on the star of ADD REPUTATION under my comments.