I'm working with ArcMap 10 and have some trouble joining a shapefile and a .xlsx file.
The .xlsx contains sensor data (CO2, NO2 etc.) without location information. The shapefile contains all the sensor locations. Sounds easy but here is the problem:
The .xlsx file contains data from multiple points in time (every 5 seconds of a single day). It looks like this in ArcMap:
And the Shapefile attribute table looks very simple:
I Want to join the two based on ID, which is the matching sensor number. A basic join obviously won't do the trick. I tried to mess around with creating a Query Table but could not make it work. How do I do this?