I could use some suggestions on how to separate names that are lumped together in one field in an imported data set.
The name field can include one of the three formats
1. Mark White & Jean Sanchez
2. Harold & Bernadette Katz
3. Mary Jane Kennedy
What I would like to do is to have a query that can convert the single field into potentially 4 new fields that I will add to my table. The desired result is shown in the screenshot.
Is it possible to write an update query that could do this with all of the potential variation?