Manipulating CSV Duplicates

by

I’m working on my webshop and I’ve found out there are many combinations I need to sort.

I need to find all name duplicates and name them with the same ID number.
I’m using a program called CSVed but any other program will do.

This is what it looks like right now.

And this is what i need it to be,

All duplicates get the same ID code
It does not matter what number they get, they only need to be the same.

It would save me hours maybe days of work if someone knows a tip or tool to sort this.

Answer

This problem is solved. The solution is, Use excel and remove all duplicates. then make a new colomn with random numbers next to it. Then use the VLOOKUP command and thats pretty much it !

Attribution
Source : Link , Question Author : anton , Answer Author : anton

Leave a Comment