Transpose data from one format to another

[jimmyhartington]

I have som data, which does not come correctly as rows and columns as I need.

This is my input:

And this is my desired output:

And here are some example files.
Example files

It is probably very simple to do, but my monday brain is not able to do it

[Admin]

The Spread transform is your friend:

[jimmyhartington]

I knew it was simple.
Thanks a lot.