Increment duplicate IDs by a dash + 1

[TheHack22]

Hi VBA Gurus,

I hope everyone is doing well. I have this list of Customer IDs and the number of payments for this check run.
It's company practice to increment the IDs by -1(Manually), adding one each time, while doing nothing with the first ID instance. Please see the small example below.

Is there a way to make this a repeatable process Power Query, or any other methods?

IDS	Desired New IDs
Imr2022581	Imr2022581
Imr2022581	Imr2022581-1
Imr2022817	Imr2022817
Imr2022817	Imr2022817-1
Imr2022986	Imr2022986
Imr2022986	Imr2022986-1
Imr2022321	Imr2022321
Imr2022321	Imr2022321-1
Imr2022321	Imr2022321-2
Imr2022878	Imr2022878
Imr2022878	Imr2022878-1
Imr2022878	Imr2022878-2

Thanks
Imran

 

[Fluff]

Duplicate to: Increment Duplicate value by a dash and 1

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.