I work for a city and I need to track collisions to spot problem areas. I have a table that has a column for the reported (primary street) and a column for an intersecting (secondary street). Depending on how its entered by police officers, Main St. could end up in either column. So if I have 5 collisions say Main street & 3rd, Main & Walter, Walter & MLK, MLK & Main, 3rd & Main; I would like the pivot table to List Main St once with total of 4 instances, 3rd = 2, Walter = 2, MLK =2, etc.
Also is there a way to do a pivot table that groups by intersection no matter which street is primary? So it would list Main Street & 3rd and would have 2 instances.
Sorry if this is the wrong place or if it's been answered before, I have no clue what to search because everything I've thought of to search doesn't come close to what I'm needing. Thanks
Bookmarks