I have a column with the following names:
"John Doe", "Susie R. Que", "joe & Jill smith", "sam and karen hill"

I want the output to look like:
first name: John, susie R., Joe & Jill, sam and karen
last name: doe, que, smith, hill

Is there a way to do this?