spilt and combine data in columns

[Ksisterhen]

see example of output i am looking for based on the input, tabs included in attachment

[CoG]

Here is one approach to transform input into output: