How to handle merged cells and transpose the rows into columns?

I have such data in the excel file:

and I would like to format the structure of the data:

I want something like

What approaches can you recommend?

from How to handle merged cells and transpose the rows into columns?