I have the following column of ascending values:
sequenceID
1
395
1231
1231
1856
1856
1856
1856
4391
4644
4644
4644
4644
6313
7384
8301
8572
8572
8572
I want to change it to consecutive ascending values like this:
sequenceID
1
2
3
3
4
4
4
4
5
6
6
6
6
7
8
9
10
10
10
Is there a neat function that does this? I don't even know how to search on this to be honest so I apologize if something similar has already been asked.
