Dear all,
I'll get straight to the point:
These are samples from my two data sets.....
(1) two columns........
AFGHANISTAN KABUL 9320
Afghanistan Mobile-AWCC 9370
Afghanistan Mobile-Other 9371
Afghanistan Mobile-Other 9372
Afghanistan Mobile-Other 9375
Afghanistan Mobile-Roshan 9379
Afghanistan-Proper 93
Aland Islands 35818
Albania 355
Albania Mobile-Other 3553
Albania Mobile-Other 3556
ALBANIA TIRANA 3554
Albania-Mobile-AMC 35568
Albania-Vodafone Mobile 35569
and (2), two columns...........
AFGHANISTAN KABUL 0.0986
Afghanistan Mobile-AWCC 0.0995
Afghanistan Mobile-Other 0.0995
Afghanistan Mobile-Roshan 0.0995
Afghanistan-Proper 0.0986
Aland Islands 0.0119
Albania 0.0317
Albania Mobile-Other 0.0770
ALBANIA TIRANA 0.0180
Albania-Mobile-AMC 0.0770
Albania-Vodafone Mobile 0.0770
the names inputed into the first column are in the SAME format in each data set, but there is NOT the same NUMBER of occurences in each data set which has caused me troubles when I try and merge the data.
I would like to be able to merge the data like this:
(3)
AFGHANISTAN KABUL 9320 0.0986
Afghanistan Mobile-AWCC 9370 0.0995
Afghanistan Mobile-Other 9371 0.0995
Afghanistan Mobile-Other 9372 0.0995
Afghanistan Mobile-Other 9375 0.0995
Afghanistan Mobile-Roshan 9379 0.0995
Afghanistan-Proper 93 0.0986
Aland Islands 35818 0.0119
Albania 355 0.0317
Albania Mobile-Other 3553 0.0770
Albania Mobile-Other 3556 0.0770
ALBANIA TIRANA 3554 0.0180
Albania-Mobile-AMC 35568 0.0770
Albania-Vodafone Mobile 35569 0.0770
so, for example where I have "Afghanistan Mobile-Other" occuring three times in my initial data set (9371, 9372, 9375), I would like ALL three of these to similarly appear in my final data set, even though the value they correspond to (0.0995 in data set 2) is the same.
I haven't been able to work this with the standard "merge workbooks" function. Is it possible this way or do I need to try another line of attack?!
Please help me, there is precious little hair still attached to my scalp!
Thanks
Tom
Bookmarks