View Single Post
  #2   Report Post  
DOR
 
Posts: n/a
Default 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.