Reverse combinations in different columns

[DavidAC]

Hi,
I appreciate there is probably a simple answer to this but i am stuck.

We have a 4 column spreadsheet which has over 20K records in it. Column A & B are text fields and C & D are numeric fields. What we need to do is to ensure the combination in the text fields is reversed and also in the list. So

Column A. Column B. Column C. Column D.
London. Edinburgh. 300. 250

We need to ensure that
Column A. Column B. Column C. Column D.
Edinburgh London. 300. 250

Is also in the list. Hope that makes sense

 

[Yongle]

Try this:

Copy everything to a new sheet
In new sheet...
Insert a new column at column A
Copy column C to Column A and delete column C (this has now reversed place names)
Copy the values again from the original sheet and paste directly below the values in the new sheet
Select the data \ click on Data Tab \ click on Remove duplicates

Duplicate rows will be removed, hopefully leaving you with the two-way data you want

NOTE
Dupicates are treated as duplicates if all 4 columns are identical (ie the numbers must also match up)