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

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:

Rows to columns.yxmd