Forum Discussion

Kathleen Leal's avatar
Kathleen Leal
Copper Contributor
Aug 29, 2018

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 duplicates) - all without using a pivot table.

My list/table is below... can anyone help?

01-6512-0-5210-5060-2200-622-0000
01-6512-0-5210-5060-2200-622-0000
01-6512-0-5210-5060-2200-622-0000
01-6512-0-5210-5060-2200-622-0000
01-6512-0-5210-5060-2200-622-0000
01-6512-0-5210-5060-2200-622-0000
01-6500-0-5210-5060-2200-622-0631
01-6500-0-5210-5060-2200-622-0631
01-6500-0-5210-5060-2200-622-0631
01-6500-0-5210-5060-2200-622-0631
01-6500-0-5210-5060-2200-622-0000
01-6500-0-5210-5060-2200-622-0000
01-6500-0-5210-5060-2200-622-0000
01-6500-0-5210-5060-2200-622-0000
01-6500-0-5210-5060-2200-622-0000
01-6500-0-5210-5060-2200-622-0000
01-6500-0-5210-5060-2200-622-0000
01-6500-0-5210-5060-2200-597-0000
-------

Resources