Displaying 1 result from an estimated 1 matches for "tp4646559p4646609".
2012 Oct 18
3
replacing random repeated numbers with a series of sequenced numbers
Hi all,
I have a dataset with one column like below:
ID
1001
1001
1001
1122
1122
1122
1421
1421
1789
1789
..
These numbers are no in sequence and they have different repeats. How could
replace them with sequenced numbers?
Such as follows replacing the ID column with the SID column.
ID SID
1001 1001
1001 1001
1001 1001
1122 1002
1122 1002
1122 1002
1421 1003
1421 1003
1789 1004
1789 1004