Street Index Lookup Table in ArcGIS Pro

JamesBooth

I have a Map Series I have created using an existing feature class (GRID) with a designated field as the Name Field ("NAME").  I am trying to determine the easiest method to create a Street Index Table using a Streets Feature Class (polyline) that contains a "Road Name" attribute, and the GRID Feature class (used in the Map Series) that contains a Grid name.

What would be the easiest way to create such a table that allows me to format the results and make it aesthetically pleasing as well? 

Essentially, this is what I would be looking for as an example:

Albert Street........................................................................................R-9,R-4

Buffer Avenue.....................................................................................R-1, R-3, R-6

Cedar Court........................................................................................R-7

Smith Street.........................................................................................R-1, R-2, R-5

Appreciate any help people can provide!

SLouq

Create a new text field in your rd feature class. Do a spatial join between your Rd feature class and you grid feature class (Choose within match option). This should join your grid and roads together. Once you have two feature classes, (Road feature class and Grid feature class) perform a regular join between the two and then use the field calculator to concatenate the Road name and grid cell into the new field created in your Road feature class