Hi Guys,
What I am trying to do is create a new column called ID. The ID will then increment by one each time the condition is not satisfied. The ID value will continue to increment until the end of the dataset. In the example below I am looking at the name and address columns.
An example of what I would like the final outcome to look like is below.
Name Address ID
Andrew 1 John Street 1
Andrew 1 John Street 1
Laura 2 Steve Street 2
Laura 2 Steve Street 2
Mike 3 Jane Street 3
Nathan 5 Smith Street 4
Thanks in advance for any help that you may be able to provide.