Removing Duplicates from one column to another - without Pivot table

I am hoping someone can help me. I have a column of text numbers, some of which are duplicates.  I need to have the duplicate numbers only show up once in a different column (like removing duplicate...