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
118 freelancers are bidding on average $102 for this job
Hi, I am ready to start work on this project immediately. I have very good excel skills, I will complete this work within a time frame exactly with your requirement.
Human typo error free deliverable as I will accomplish this task by building an utility in VBA. Please check PMB for a brief on your task will be accomplished.