I have a table exported from a database that I am attempting to splice into two tables.
The one table contains a list of records and their spouses along with IDs.
123 Sue Smith 895 Steve Smith
895 Steve Smith 123 Sue Smith
Each spouse is listed twice - one as the main record or "constituent' and the other as the spouse.
How do I separate this into two tables where I can have the following:
table one: 123 Sue Smith
table two: 895 Steve Smith
I have exhausted any imaginative thoughts I have about this - any help would be greatly appreciated!
Thank you in advance,