concatenate multiple rows into one with Comma separation

[AJ-CH]

Hello, 

I am trying to find a solution to merge multiple rows into one row.

Input
CN	Item
A	ABC123
A	ABC456
B	ABC789
B	ABC789
C	ABC012
D	ABC001

Desired Output
CN	Item
A	ABC123, ABC456
B	ABC789, ABC789
C	ABC012
D	ABC001

any help will greatly be appreciated.

[Thableaus · Accepted solution]

Hi @AJ-CH 

Use the Summarize tool, grouping by CN field and using String concatenation on the Item field.

Cheers,

[Thableaus · Accepted solution]

@AJ-CH 

Example attached.

Cheers,

[AJ-CH]

@Thableaus, thanks for quick solution.. it worked.. 🙂