I have a single column A with 7000 rows. There are some duplicates among the data, like:
- john-smith
- pattie-walk
- john-doe
- john-smith
- anna-hey
I need to append each duplicate entry with number, so john-smith should look like john-smith-01. If multiple john-smith exists it should keep adding numbers as -02,-03,-04 and so on for each duplicate entry. But also, the unique cells should be copied as they were.
- john-smith-01
- pattie-walk
- john-doe
- john-smith-02
- anna-hey
Any help with the formula is appreciated.