Combine Rows of Data into Separate Columns by Unique Identifier

[amandaj4123]

I could use some SUPER DUPER smarty pants help here.  I have searched the Community and, so far, none of the existing suggestions have resolved my issue.

I have an Unique Identifier "ID" which could have 3-5 rows of data.  I would like to separate the "Value" column into separate columns, indicating the value in the "Amount" column.

[MarqueeCrew · Accepted solution]

Use a cross tab

Group by Id, name & date

Header = value
Value = amount

That should do it.

[nick_ceneviva]

Are you looking for the Cross Tab tool?

You can specify your grouping field (ID, Name and Date in your instance).  Your header fields would be the value column and the value field would be your Amount Column.  Because there wouldn't be any aggregation, you will be okay choosing sum.

[gnans19]

Same approach. Attached smple workflow

[amandaj4123]

That resolved my issue.  I kept attempting Transpose with Cross Tab and coming up with errors.  Thanks for the quick response!  Sometimes, the answer is more simple than we think it is.