Hello,
we have done a public survey and have a list of zip codes/post codes and want to know which ones fall into each councillor wards (polygons).
The same zip codes/post codes can be repeated because there is more than one entry in the spreadsheet depending on the amount of people living in the same area having taken part .
All I have been able to do so far is a Join between the spreadsheet and a spatial dataset of zip codes/post codes but this only gives me a one- to one join and although I can then do a spatial join with that data and councillor ward polygons it isn't giving me a count of how often the same zip code/ post code occurred but rather only a list of each single zip code/post code and the corresponding councillor ward polygon
I hope this makes sense?
Thanks
