Remove text after comma

[sericson]

I have data that depending on the input can produce duplicates in one box, I need to be able to remove everything from the first comma and over while keeping the data in other rows that are not duplicates. I have tried several formulas, RegEx etc.. I can't seem to get it quite right. 

example of how it is formatted now

Install type

Reallocate

Mapping

Reallocate,Reallocate,Reallocate

Example of how I need it to look

Install type

Reallocate

Mapping

Reallocate

[griffinwelsh]

You can do this using the text to columns tool and the unique tool. Sample solution is attached for you.

[Qiu · Accepted solution]

@sericson 
We can also try the RegEx