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 |
Solved! Go to 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.
Hi @hellyars
You can clean it up either before the summarize or after do a new summarize logic. See below:
Pedro.