Transpose data, turning column values into columns.

[fitch1892]

I have row values in a column that I want to create them as column names with their corresponding values. Can this be done with a transpose tool?

This is what I have... 

ID | key | value

1    color   red

1    shape round

1     size    small

And I want this...

ID | color | shape | size

1     red     round   small

[DataNath · Accepted solution]

Hey @fitch1892, you just need to use the Cross Tab tool here. Group by ID then set the [Key] as your headers and [Value] as value:

[fitch1892]

This worked great! Thank you!