Transpose data from one format to another

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 :slight_smile:

The Spread transform is your friend:


I knew it was simple. :slight_smile:
Thanks a lot.

1 Like