I have a point feature class of addresses and an excel spreadsheet of all the suites associated with each address. I need to create a point for each suite belonging to an address. Is there a way, using arcpy, to scan the excel, match addresses, and then explode each point to create a new point for each suite?
I would like to create a tool so that I don't have to go through each record manually but i'm not sure where to begin. I've done some searching but most of the information I have found is about deleting duplicate points not creating them. Has anyone come across this sort of problem before or know of any good tools that do this?
I am using Arc 10.2.2