Excel data organization

IN PROGRESS
Bids
118
Avg Bid (USD)
$102
Project Budget (USD)
$30 - $250

Project Description:
I have 5000 lines of excel data that i need organized in a certain way. Basically, they need to be put under the proper headings on the top row of a sheet i already have created, and then I can import them into a customer relationship management program.

This will not only involve moving information laterally across cells, you will also have to split information that is in one cell, that should go into two. The difficulty will lie in that some of the lines do not have all the data, subsequently if the information is not in the sheet, a blank space should be shown. The next challenge will be that some of the information will need to be put together, for example if the suite is separate from the address, they will need to be combined with a comma in between. The last challenge is that each line starts with the name but the rest of the information is not organized correctly, if something is missing. Please see the attached sample sheet.

The final headings should be:
First - Middle - Last -Title- Firm- Street Address, Suite (if applicable) - City - State - Zip - Phone

If this is something you believe you can accomplish for me, let me know

Thanks,
Jon

Skills required:
Data Entry, Data Processing, Excel
Additional Files: Freelance+Sample.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.