I would suggest you use ACCESS - Paste all of your data with the Names
into 1 table in ACCESS. Paste your rows with cities in another table -
generate a query which can pull the information together. The
connection between the 2 would be the "AAA."
--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile:
http://www.excelforum.com/member.php...o&userid=29640
View this thread:
http://www.excelforum.com/showthread...hreadid=498193