You have chosen to sponsor your bid up to a maximum amount of .
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