Closed

Excel data organization

This project was awarded to torajiv for $35 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
118
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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online