I have a polygon layer of a grid of USGS Quads Index clipped to the Southwestern US (https://catalog.data.gov/dataset/united-states-7-5-usgs-quad-index). I also have a polygon layer of county boundaries (https://www.census.gov/geo/maps-data/data/cbf/cbf_counties.html). I would like to create a new field in the quad index file that lists all of the counties that each quad intersects. I know I can use Intersect and Union in QGIS and ArcGIS, but the trouble is that there are duplicate rows for each Quad. Whereas when I started there were 4080 records (1 for each quad), there are now something like 5852 records (multiple for each quad). Like this:
I basically want the original 4080 records (1 for each quad) but with a list of all the intersecting counties. Something like this:
What is the right process for doing this in ArcGIS Desktop?
I was looking at the "Make Query Table" option in ArcGIS.