Merging Text Help
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.
|