Hi,

From a database, I have imported (into Excel) two lists of statistics
by country: (list a) the 20 countries with the largest number of cell
phone users, and (list b) the 20 countries with the highest percentage
of cell phone users. I want to match these two lists by country so
that the names and their corresponding statistical information will
appear in the same row in every case where a country exists in both
lists. For those countries that don’t appear in both lists, I would
like for each of them, along with its corresponding statistical
information, to appear in its own row.

Does Excel 2003 have a function or tool that can reorganize the data in
this way?

Thanks,
tettrick


--
tettrick
------------------------------------------------------------------------
tettrick's Profile: http://www.excelforum.com/member.php...o&userid=14356
View this thread: http://www.excelforum.com/showthread...hreadid=398855