Forum Discussion
Kathleen Leal
Aug 29, 2018Copper Contributor
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 |
------- |