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

[brendafos]

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 solution]

@brendafos

All it takes is a summarize tool!

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

[brendafos]

Worked perfectly. 

The Summary tool continues to amaze me.  I need to learn more uses of it.

Thanks.