Spreadsheet data clean up for import to database

I have an excel spreadsheet with 5200 names and contact details listed. The spreadsheet has data that includes multiple details in each cell (Eg One cell many include full contact details such as name, address, phone number etc.) Some cells have two people with their full details listed. I require this data to be transferred into individual cells so that I can import it into my contact database. I have attached a spreadsheet with a fictitious sample of the data (tab 1: existing) and a spreadsheet with the fields I would like to have (tab 2: new)