In Progress

Excel data organization

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: Data Entry, Data Processing, Excel

See more: excel data organization, sample organization data excel, top data, relationship challenge, me excel, excel challenge, excel 16, example challenge, data challenge, data organization excel, jon n, final data, line sheet, jon, excel data sheet, excel data processing, customer relationship management, city state excel sheet, excel split sheet, excel split, excel cell, data program excel, excel data management, excel sheet customer management, excel split cell

About the Employer:
( 2 reviews ) Westfield, United States

Project ID: #938954

Awarded to:

torajiv

I can create an sql query which will do this task automatically, quickly and accurately

$35 USD in 1 day
(31 Reviews)
4.9

118 freelancers are bidding on average $102 for this job

FINGERRPRINT

Can Be Done perfectly. Please See Our Pm

$225 USD in 5 days
(174 Reviews)
7.4
Innovative116

Hi. Please check PMB for more details

$200 USD in 4 days
(155 Reviews)
7.4
jkrish

Please refer PM for details.

$240 USD in 7 days
(73 Reviews)
6.2
koolsidz

Please see PMB

$110 USD in 2 days
(111 Reviews)
6.0
spawar

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.

$100 USD in 5 days
(49 Reviews)
5.9
vsona

Greetings! Thank you very much for giving us an opportunity to bid for your project. Please refer to PMB for our detailed bid.

$55 USD in 2 days
(72 Reviews)
5.9
iasmumbai

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.

$50 USD in 3 days
(121 Reviews)
5.6
vbexcel

Ten years experience.

$60 USD in 1 day
(28 Reviews)
5.5
Johir08

Ready to start now.

$185 USD in 5 days
(15 Reviews)
5.0
emmalancer

Lets Start & get it done perfectly...Check your ++++++++++++++++++++INBOX++++++++++++++++++for details

$150 USD in 7 days
(42 Reviews)
5.0
jmddata

Let's Start..!! :):)

$250 USD in 5 days
(22 Reviews)
4.9
carmenli

Hello. I am very much interested in this project. Please check private message for sample and further information. Thank you, Carmen

$90 USD in 5 days
(30 Reviews)
4.8
Akshat06

We can prepare this for you. This sound interesting as extraction needs precision to carry all the way to end. Just one data in wrong column can ruin your Customer Relationship Management Program. Try us, we will not t More

$150 USD in 1 day
(1 Review)
4.7
yen033

pls see my pm.thx

$35 USD in 25 days
(6 Reviews)
4.7
dev3dworx

Please check PMB for details.

$250 USD in 7 days
(19 Reviews)
4.7
dipak123

100% ACCOMPLISHMENT ASSURED. PLEASE CHECK PMB FOR DETAILS.

$90 USD in 10 days
(33 Reviews)
4.6
OnlineeWorker

Please check PM.Thanks

$130 USD in 2 days
(10 Reviews)
4.3
mantripti

Hi, I have a team support of a Mechanical Engineer, M Tech & MBA, Cost Management Accountant. I also have a team support of number of professionals, including IT engineers, Computer professionals. We also have a manpow More

$125 USD in 3 days
(23 Reviews)
4.2
muthumuni

(((((Your Search End Here!!!))))) {{{{{{Please Just Check PMB}}}}}

$30 USD in 0 days
(10 Reviews)
4.0
shabukumar

Please refer inbox.

$100 USD in 25 days
(15 Reviews)
3.9