Freezing first line columns to rows

[Lauritsjust]

Hi all

I am trying to "freeze" the first column and move other columns to a new row with the frozen column as an account identifier in the first line. 

My input looks something like this:

and I would like my output to look like this:

However, when I do it, it keeps putting the new rows in different columns instead of column 2-4.

Any suggestions? 

[atcodedog05 · Accepted solution]

Hi @Lauritsjust 

please find my updated solution. Assumption 1 is always account you can also add more columns it will get adjusted.

Hope this helps : )

[Lauritsjust]

Thank you all, I combined some of the answers and now I have a working solution. 

[atcodedog05]

Happy to help : ) @Lauritsjust 

Cheers and have a nice day!