Looking to have another column with consective counts for each record based on the ID group.
For instance, Row 1 (A29GFL) would be 1, Row 2 would be 2, Row 3 would be 1.
The count is all based on location, so the first time an ID appears would be 1, the 2nd time it appears would be 2 etc...
@Peace_B1
I also agree that Tile Tool is best fit in this situation.
Just for better understanding, here is a different approach.