Question regarding duplicate rows except for one column that has unique data

[Goshawn]

Good afternoon,

I am running an excel report through Alteryx. There are duplicate rows that I am wanting to get rid of. However, there is one column of data in these duplicates that are different. IF you see the attached picture, it has the same structure as my spreadsheet, but with data changed. The value that I am using to identify the duplicates is the "CW Number" column. You can see that all the data is the same, except that there are different "On Behalf Ofs" listed (which is why there are duplicate rows).

My question is this: is there a way to get rid of the duplicate rows, but have all of the "On Behalf Ofs" listed in one cell? 

[davidskaife · Accepted solution]

Hi @Goshawn 

A simple solution works, use the Summarize tool to Group By on all the fields, except 'On Behalf Of' - which you Concatenate:

[Goshawn]

I believe this worked! Thank you for the assistance!!