Transpose and add lines

Hello,

I would very much appreciate your help with following transpose:

I have a simple table (first attachement) and would like to transpose it, so the outcome is in the second attachement.

Could you please help?

Thank you very much!