Hi,
Does anyone know how to remove duplicate emails in a cell?
Ie
Louis.Stevens@hotmail.com; Louis.Stevens@hotmail.com; Louis.Stevens@hotmail.com; Ren.Stevens@hotmail.com |
to become
Louis.Stevens@hotmail.com; Ren.Stevens@hotmail.com |
and applied for a whole column?
Thanks.
Solved! Go to Solution.
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!
The Link shared is not working, can you please update the new link. Will help me too.
Thank you , this works. But how to apply this across multiple columns without having to repeat this all the time?
Text to columns : Delimiter ";" and split to rows
Summarize: Concatenate and Separator ";"
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!
Hi @htalteryx
I suggest you to create a new topic showing a dummy sample of how your input/expected output looks like.