Hello, I am trying to find a solution to merge multiple rows into one row. InputCNItemAABC123AABC456BABC789BABC789CABC012DABC001 Desired OutputCNItemAABC123, ABC456BABC789, ABC789CABC012DABC001 any help will greatly be appreciated.

concatenate multiple rows into one with Comma separation

Hello,

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

any help will greatly be appreciated.

Help

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

Cheers,

Example attached.

Cheers,

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

Cheers,

Example attached.

Cheers,

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