I am repeating the question that was previously answered. I need further transposing for columns in the database, hence, I am reposting the question:

Parsing First Name and Last Name

Example below, a customer can have many contacts:

cust_no contact name Phone Cell fax email

1234 John Doe 123-456-7890 312-456-7890 123-456-7890 [email protected]
1234 Jack Smith 451-839-9752 451-980-9752 451-980-9752 [email protected]

I would like to parse John separately from Doe and store the values in different columns called, FirstName1 and LastName1. Similarly, I would like to have FirstName2 and LastName2 columns for Jack and Smith respectively after having parsed the values from contact name column. The result should be as below with unique cust_no. Furthermore, I would like to have corresponding Phone, Cell, Fax and email for John Doe and Jack Smith as shown below:

cust_no FName_1 LName_1 Phone_1 Cell_1 Fax_1 email_1 FName2 LName2 Phone_2 Fax2

1234 John Doe 111-111 333-333 4440 [email protected] Jack Smith