Removing duplicate values in each cell

[wonka1234]

Hi,

Does anyone know how to remove duplicate emails in a cell? 

Ie 

Email

Louis.Stevens@hotmail.com; Louis.Stevens@hotmail.com; Louis.Stevens@hotmail.com; Ren.Stevens@hotmail.com

to become

Email

Louis.Stevens@hotmail.com;  Ren.Stevens@hotmail.com

and applied for a whole column?

Thanks.

[ShankerV]

hi @wonka1234 

Please find the solution.

[Felipe_Ribeir0 · Accepted solution]

Hi @wonka1234 

One way of doing this

[dana_mcdonough]

Hi @wonka1234 : here is a great resource outlining different approaches to removing duplicates within a cell: Remove-Duplicates-within-a-cell 

Let me know if this helps!

Dana

*updated link* apologies!

[ShankerV]

Hi @dana_mcdonough 

The Link shared is not working, can you please update the new link. Will help me too.

[wonka1234]

@Felipe_Ribeir0  

Thank you , this works. But how to apply this across multiple columns without having to repeat this all the time?

[Felipe_Ribeir0]

Hi @wonka1234 

You can transpose the dataset before removing the duplicates:

[EN6924]

Text to columns : Delimiter ";" and split to rows

Summarize: Concatenate and Separator ";" 

[htalteryx]

I have multiple fields (10+ fields) with duplicate values in the cell.  How would you solve?  Is there a better way than copying/pasting ShankerV's solution multiple times on the canvas?  Thanks in advance!

[Felipe_Ribeir0]

Hi @htalteryx 

I suggest you to create a new topic showing a dummy sample of how your input/expected output looks like.