How can I combine text strings that are in a different order?
Hard to explain in words, but the attached file should clarify my problem. I have data for a number of airplane tickets with originating (column ORIGIN) and terminating (column DEST) airports. I also combined these to show the route. But I want the route from A to B to be the same as the route from B to A. Right now, this will appear as two different strings, for example ANC to ADK is distinct...