AnsweredAssumed Answered

Excel/ArcMap - After Geoding Unique Values Gone How to Use Excel to Match and Combine Data?

Question asked by kenric03 on Apr 15, 2015
Latest reply on Apr 15, 2015 by sephefox

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 1Set 2
1 3 110 Street99 110 Street
2 4 111 Park100 111 Park
3 5 112 Road101 112 Road
4 3 113 Ave102 113 Ave
5 9 114 Lane103 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!

Outcomes