How to add Sequential numbering to existing integer

Ask a question
1

I have a column that contains duplicate numbers:

100
100
100

I need to create

100-1
100-2
100-3

Any help would be appreciated

2

Hi @Julian_Partridge - Happy to help! You can use an Add row numbers step and have the numbering be depending on the column with the duplicate numbers.

From there, you can use a Merge columns step to combine those columns to create the 100-1 formatting that you want for those numbers.

Let me know if you have any questions!

3

Thank you that worked perfectly!