Change rows to columns - concat the values form rows into a single new column

Question

I have more than one row when one field has more than one value for the field.

Two examples in yellow - each yellow area is a duplicate row ONLY because the last column has two vavlues.

I would like a single row per name (second column), with the last column 'SJH' in  a row, then another row with 'EGS'  - I would like to be a single column/field with 'SJH, EGS' concat'd

There could be more than 2 but not more than 5 rows for any name.

How best to do this?

I tried Cross Tab but I need a new feild to put the values in.

Please suggest how to do this.

Thanks.

JoeM · Accepted Answer

@brendafos

All it takes is a summarize tool!

In the summarize tool, group by [longname], and concat [entity_k]. Example attached.