I have 2 columns, name1 and name2, that contain numerous rows of possible names.

For example: John Citizen, Jane Taxpayer, Citizen John, Taxpayer Jane, etc...

One partial name is stored under name1 and another partial name is stored under name2. I was wondering how would I be able to delete all of the names that appear in a table so that there is only one entry for every possible name? For example John Citizen or Citizen John would exist, but not both. So in the end I would get:

```
John Citizen
Jane Taxpayer

```

or...

```
John Citizen
Taxpayer Jane

```

or...

```
Citizen John
Taxpayer Jane

```

or...

```
Citizen John
Jane Taxpayer

```

**EDIT: Just to clarrify, name1 = John, name2 = Citizen for example. They've already been broken up into their respective columns so I just need to select unique combinations between the two columns.**