Index Column that resets based on another column value

In this example, the index resets when the location changes.  Here is the example below:   City Index WhatIndexShouldBe New York 1 1 New York 2 2 New York 3 3 London 4 1 ...