How do I replace/ recode string with unique number
I have a dataset with > 1M rows and a particular 'Supplier' column with 3400 unique suppliers (data type Character, Nominal). These suppliers have a rather user-unfriendly format, e.g; '0x384D5E35468AB867642A475A2B526AE264E37B9E'. How can I replace (recode into new column?) the 3400 suppliers by a unique number from 1 -> 3400?(In Excel I would create a Pivot table and then re-match using xlookup)U...