Put the city list in column A of sheet1 and the Occupation list in
column B. In sheet2 cell A1 put

=Sheet1!$A1&" "&INDEX(Sheet1!$B:$B,COLUMN())

Copy across to include all occupations and and down to include all
cities.

Save sheet2 as a CSV file.

Thank you - Works Wonders. I wish I knew how you came up with the
formula.

Mark


--
MarkyD
------------------------------------------------------------------------
MarkyD's Profile: http://www.excelforum.com/member.php...o&userid=28590
View this thread: http://www.excelforum.com/showthread...hreadid=482552

You're welcome.

To understand formulas like this, look up a few things in Excel help:

1. Enter "cell references" in the answer wizard and then click on "The
difference between abslute and relative cell references" on the right
hand side.

2. Do the same for "column function" and read about that.

3. Then read about "index function".

4. Finally, read about "concatenate" (the & joins strings together -
that's called "concatenating".