How do I transpose columns in Excel?

I have a spreadsheet that looks like this:

I want to automatically transform it to this:

:

I know I can transpose it using this Window:

But the result is like this:

How can I get what I described?