Advanced transpose table

Hello forum,

I need to transpose a two column table into horizontal table. However, after making the table horizontal one of the row becomes a header. I want to merge headers into one and combine data into columns under each header. Please see the image below. Its been over an hour and i cannot figure out how to do this.


Thank you for taking time.




2i0qema.jpg