in my dataset, I would like to simplify the case ID attribute.
My data is from ticketing system and sorted as each row = a status change within the case (ticked). This means, each case ID is the same for 2 - 7 rows depending on the complexity of the case (ticket).
At the moment, the case ID is quite complicated and I would like to replace it with simple numbers 1, 2, 3 etc.
This means, everytime the case ID changes (provided the dataset is sorted by case ID), new number in the line 1, 2, 3… would be generated. Example:
Current case ID Desired case ID
Please, how to do it in a bulk? I have a feeling that loops could help but I am not experienced enough.
Thank you so much.