I have a listing of data that contains duplicate reversed pairs and I need to remove them.. Call them, name1 and name2. Where I have Tom and Mike, and Mike and Tom, such that this single pair is being counted twice.
name1 | name2 -------|------- Tom | Mike Pete | Jenny Bill | Jenny Joe | Mary Mike | Tom Jenny | Pete Jenny | Bill Mary | Joe Linda | Jenny
The List was a product of an initial match of student with guidance counselor, then the product of the student/counselor and counselor table, which resulted in a longer list and was able to reduce to the pairs above. But, now can't get rid of the duplicates.
While I might have made a mistake in combing the tables that made the pairing, I am stuck with that table for now.. This is a listing of student paired with guidance counselors.
Is there a way to de-dup the list, or do I need to start over?