Remove duplicate email addresses from a column

[wonka1234]

Hi,

Say I have a column like :

louis.stevens@gmail.com;ren.stevens@gmail.com;louis.stevens@gmail.com

How can i get it to be 

louis.stevens@gmail.com;ren.stevens@gmail.com

thanks.

[Raj]

one way to achieve this
please find attached.

[flying008]

Hi, @wonka1234 

FYI.