Combine Rows of Data into Separate Columns by Unique Identifier

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.

Preparation

Accepted answers

MarqueeCrew

Use a cross tab

Group by Id, name & date

Header = value
Value = amount

That should do it.

All comments

MarqueeCrew

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

CrossTab.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703