pivoting the data from a vertical layout to a more horizontal layout.

[ABC_Anonymous]

I can't transform this input to the output, I always get a single line with concatenations

[OTrieger]

@ABC_Anonymous You can get rid of Name and then Cross Tab and Transpose the data and you will get what you are trying to. Group the data based on ID in both tools

[OTrieger]

I prefer to do it with Summarize tool, Group on ID and Name, Concatenate Value.
Then you can Text to Columns the move the first row to be Headers 

[ABC_Anonymous]

BUT THERE ARE N COLUMNS TO BE HEADERS

[OTrieger]

A different way will be to use Make Columns tool, before connecting it you will need to get rid of Name header. Set it to Arrange Horizontally Grouping based on ID and then Cross Tab the data 

[OTrieger · Accepted solution]

[ABC_Anonymous]

Perfect !! Big Thanks very useful