Hello,
I have been trying for some time now to do this, and it is very frustrating.
After I geocoded, I now have the X and Y values and the addresses, but I do not have the unique number associated with them. There are thousands of them, so I cannot add them manually because of the time frame.
Here is an example of what my current data looks like...
In "Set 1" the first and second numbers represent the x/y coordinates. Then, it is the street address (110 Street, 111 Park, 112 Road, 113 Ave, and 114 Lane).
In "Set 2" the first number represents the unique ID. Then it is the street address (110 Street, 111 Park, 112 Road, 113 Ave, and 114 Lane).
| Set 1 | Set 2 |
| 1 3 110 Street | 99 110 Street |
| 2 4 111 Park | 100 111 Park |
| 3 5 112 Road | 101 112 Road |
| 4 3 113 Ave | 102 113 Ave |
| 5 9 114 Lane | 103 114 Lane |
I would like to match and combine these somehow in Excel. The final output should look similar to "1 3 110 Street 99 110 Street". Since there are thousands of entries, I need to partially match the data and then combine the two cells together. My idea is to combine the "110 Street" together since both columns share it. If there is another way I should do this, please let me know!
