Remove Duplicates After Concat

[hellyars]

I just ran a Summarize w/ concat.  I want to get rid of repeated values in records #2 and #4. 

RecordID	POST CONCAT	DESIRED OUTCOME
1	Bikes	Bikes
2	Bikes, Bikes, Bikes	Bikes
3	Cars, Bikes	Cars, Bikes
4	Planes, Planes	Planes
5	Planes, Trains, Automobiles	Planes, Trains, Automobiles

[hellyars · Accepted solution]

I figured it out.  I used Text to Column Tool set to Split to Rows using ",".  I then used the Summarize Tool to get rid of the duplicates.

[pedrodrfaria]

Hi @hellyars 

You can clean it up either before the summarize or after do a new summarize logic. See below:

Pedro.