I am working on creating an atlas index which contains the road name, the page of the atlas on which the road is located as well as the individual grid on the page. For example, Airport Rd. S-7, AX-41. The problem that i'm running into is Airport Rd. is located on one page however crosses from AX-41 to AX-42. I want to consolidate the data to read as it did above. How can I remove the duplicate Airport Rd's while keeping the S-7, AX-41 and AX-42 to look something like this: Airport Rd. S-7, AX-41, AX-42.
An expected result is below.
Any help would be greatly appreciated!