Hi
This site has other forums more suitable for this question.
Personally I think I could provide a DOS answer,
I just don't have the energy or time to waste with totally unsuitable tools.
To start with, you may need to convert the data to pure upper case (or pure lower case). It would take far to much effort to have the computer compensate for any spelling mistakes or variations in what gets a capital letter.
I suggest you use a spreadsheet.
I prefer Open Office, but Excel may also be up to it.
Just paste your multi-column table into the spreadsheet,
and so long as choose as column delimiters the Tabs, Spaces, whatever that have been used in the original document, they should appear in separate columns.
Simple spreadsheet tricks :-
1) Copy column A into empty column C
2) Copy column B and append below what has just gone into C
3) Select each column, one at a time, and sort that column
4) Select portions of A and slide down, leaving vertical gaps, so that each town is on the same row as in column C
5) Repeat "4" upon column B
6) Look at columns A and B - you should now see duplicate towns side by side.
Regards
Alan
