Fixing Data Ready For Importing
- Splitting up the First Name and Last Name - https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7
- Merge Company Names back together - https://support.office.com/en-us/article/Combine-the-contents-of-multiple-cells-3a86c317-6b91-4f1d-8781-203320aefdce
For the merging, you will need to sort by name on each column, starting at the last column, and moving back to the 3rd column. Once at the 2nd column, these are your first name and last name, and must remain split. http://www.contextures.com/xlSort01.html
Once you have the values in the first name, last name and Company Name columns, sort by company name http://www.contextures.com/xlSort01.html
C = Company
I = Individual
Put a C in the first row with a company name in it. Drag this field until the last company name
Do the same for I where there are only first and last names
Spitting up the address
This is only required if the Suburb, State and Postcode are in the same column as the address
Merge the address back together without the suburb, state and postcode - https://support.office.com/en-us/article/Combine-the-contents-of-multiple-cells-3a86c317-6b91-4f1d-8781-203320aefdce
The columns left over, rename them to the respective names "suburb, state, and postcode. The merged field, name "Address".
Phone numbers, and any number with a zero on the front, will remove the zero. Please follow this guide as the last step: http://www.upenn.edu/computing/da/bo/webi/qna/iv_csvLeadingZeros.html
Update the names of the Body types using this list: http://help.workshopsoftware.com/article/40-body-type-list If there is NO body type, or the body type isn't on this list, use the word SEDAN
Update the Transmission Types using this list: http://help.workshopsoftware.com/article/39-transmission-category-list If there is NO transmission type, or the type isn't on the list, use the word N/A.