Transpose? Pivot? Unpivot?

Hey yetanotherusern 

you can use the Pivot Operation, but first you have to prepare the table:

1. remove the empty rows
2. add an index column
3. create a grouping column (a custom column), this one is necessary, otherwise Pivot will not work

This is how the table will look after these steps:

This is the formula for the custom column.

Number.RoundUp( [Index] / 4 )

Then i removed the Index column, marked the ID column and use the transform Pivot configured like this:

And here is the result:

Hopefully, this provides what you are looking for.

Regards,
Tom