Not sure that will work either.
What I'm trying to do create a road name index for a data driven pages map book. So, I've got a map book with 300 pages and I'd like to create an index that has two fields... "road name" and "pages". Examples might be " Highway 14" "10,11,12,15,16,17"
"College Ave" "25,29,100,200...etc.".
I took my road centerlines and dissolved based on name. Then I did an intersect to break the roads at the page boundaries, then I did a spatial join to add the page fields onto the road centerlines. So far so good. But now, I have individual rows for each page that any given road shows up on. I'd like to merge all those so that the road name only shows up in one record but the pages it's on are all together in a comma delimited string in the second column, pretty much just like that image I attached in my original post. The crazy thing is, I did all this once before months ago and now I can't figure out what the tool was that did it.