Hello,
I am working with a database where I have a list of individual observations that each occur in a specified location, indicated by an ID number. Multiple datapoints can be observed at a single location ID. In another table, I have the coordinates for each ID number. What I need to do is link these coordinates to the individual observations, so that they are in a single table (as with the ID numbers, the same coords will be repeated several times if multiple observations occur at the same location). This is something that would be easily done in Access, but I am not sure how to do it in excel. Any help will be greatly appreciated.
Thank you,
Bookmarks