MichaelGaryScott
New Member
- Joined
- Feb 1, 2011
- Messages
- 6
I am having some issues marrying some data and needed some help. I have a list of customer #'s and addresses with no phone #'s on one document (List A about 1,500 rows).
And on another document a list of customer #'s and phone numbers only (List B). But on list B i have about 80,000 rows (so sorting them alphabetically and matching wont work). I want to create a relationship (using customer #) between the two so I can connect all 3 categories. I attached an example to make my problem a little bit more clear. Thanks for the help!
In the example List C is what I would like the end result to be
http://img849.imageshack.us/img849/5554/captureyi.png
And on another document a list of customer #'s and phone numbers only (List B). But on list B i have about 80,000 rows (so sorting them alphabetically and matching wont work). I want to create a relationship (using customer #) between the two so I can connect all 3 categories. I attached an example to make my problem a little bit more clear. Thanks for the help!
In the example List C is what I would like the end result to be
http://img849.imageshack.us/img849/5554/captureyi.png
Last edited:
