Combining Multiple Fields with Duplicate Data

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!

Don't think the attachment came through on my last post. Sorry!!!
In fact, I still don't know if it came through or not. New to forums...
At any rate here is how i want the data to look:

Airport Rd. S-7 AX-41
Airport Rd. S-7 AX-41
Airport Rd. S-7 AX-42

Expected Result: Airport Rd., S-7, AX-41, AX-42.
Doesn't have to be all in one field.
Again, accept my apologies for being a noob to this forum.