Column: SUPERNAME
The names are either "John Doe" or "John A Doe"
I would like to split the first and last names into separate columns, so:
John Does becomes
First Name: John
Last Name: Doe
John A Doe becomes
First Name: John
Last Name: Doe
Can anyone help me with the query formula? Thank you in advance!