Closed

Clean up Excel Spreadsheet

I need an Excel spreadsheet of client contact information cleaned up using a few simple rules. I am confident that I did not anticipate all scenarios, and it will require a bit of back and forth to complete.

There are two tabs in the attached file. The first tab needs to be converted into the second tab. I have several rows of examples in the second tab (New Client Data) to get you started.

Please begin with only the first 120 or so rows so that I can review and verify that we are on the right track.

1) For duplicate Business Name, First Name, Last Name, Phone, Email, put the duplicate inside the same cell

2) For duplicate addresses, add a new row to store the new addresses.

Skills: Excel, Data Entry, Data Processing, Data Mining

See more: excel spreadsheet vba data entry form, paste data excel spreadsheet, copying data word document excel spreadsheet, excel client data insurance form, exporting data excel spreadsheet quality center, format excel spreadsheet track artist submissions, excel spreadsheet data entry, google finance data excel spreadsheet, data excel spreadsheet set organization, data clean excel macro, excel spreadsheet client relationship management, paste data pdf excel spreadsheet, copy web data excel spreadsheet, data needed track sales excel spreadsheet, clean excel spreadsheet, how to make a clean excel spreadsheet, excel spreadsheet to track employee training, excel spreadsheet to track student progress

About the Employer:
( 0 reviews ) Northridge, United States

Project ID: #23960315

32 freelancers are bidding on average $116 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g More

$200 USD in 2 days
(751 Reviews)
8.5
Innovative116

Hi there. I checked attach spreadsheet. Transferring data from 'old client data' to 'new client data' sheet will be done within 2 days of project awarding. Everything is well explained and I am well cleared with the ta More

$125 USD in 2 days
(417 Reviews)
8.4
schoudhary1553

Hello, I can help you with your project - Clean up Excel Spreadsheet I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed seve More

$140 USD in 3 days
(356 Reviews)
8.0
mirniyazuddin92

Hi, I can clean up Excel Spreadsheet. Hi, I can clean up Excel Spreadsheet. Hi, I can clean up Excel Spreadsheet. Hi, I can clean up Excel Spreadsheet.

$100 USD in 2 days
(424 Reviews)
8.0
ponnarasiBabu

I read the project requirements - Clean up Excel Spreadsheet and went through the enclosed spreadsheet, there are 3467 rows of datas in first tab, viewed the examples and understood what need to be done, I am ready to More

$150 USD in 5 days
(428 Reviews)
7.5
P0L

Hello, I am an Excel/VBA expert and I would like to help you clean up your spreadsheet. Please check my profile and contact me to discuss further details. Regards.

$100 USD in 1 day
(351 Reviews)
7.4
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. Contact me to discuss the details. Best regards

$140 USD in 3 days
(239 Reviews)
6.9
mateenbhatti94

Dear sir I will provide you a sample for 120 rows so you can check my understanding about project. I have been in this industry for 1 year and such jobs are my daily practice. I can assure you that if you work with me More

$100 USD in 1 day
(91 Reviews)
6.4
tusharhossen123

Hi I would like to work with you. I am able to complete the work easily.i can start work now If you are interested. Please contact me. Thank you

$140 USD in 7 days
(162 Reviews)
5.9
sultanang464

Hi There, I have seen your attached file & read your details. I can clean your excel file into new tab format. there are 3468 data. i can do that perfect way. Please message me to start your work now. I can give yo More

$250 USD in 4 days
(131 Reviews)
5.9
sputnikbound

Hey, sure. I would like to work on few clean ups before as a sample. Message me, I will be able to start soon. Duplicates for 1 should be put in the same cell and duplicates for 2 in a new row.

$180 USD in 2 days
(31 Reviews)
5.6
finecodervw

Hi, I am well versed with Excel and its various features like Pivot tables, HLookup, Vlookup, SUMIF, Left, Right, Index Match, drop down, filters, charts, graphs, conditional formatting, mail merge, dashboards and can More

$75 USD in 3 days
(34 Reviews)
5.1
roytanushri13

I have gone through your excel sheet, 1st sheet has 3468 rows and 6 Columns. And 2nd one just starts. I can do that. I just need to few more things, thus I start my work. Please please feel free to chat with me, sir. I More

$100 USD in 3 days
(3 Reviews)
4.6
MonisZafar

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. I will start right away and complete it within an hour. If int More

$80 USD in 1 day
(10 Reviews)
3.8
hayteekeys

Hi, I'm a professional and expert in Data works or projects..My skills and services include: - Web scraping - Data entry - Data mining - Data processing - Excel - MySQL - Oracle -Financial Analysis -Advanced Excel -MS More

$30 USD in 1 day
(2 Reviews)
3.3
androaiad

Hello dear, I am a M.Sc. Researcher. I am expert in Excel so I can help you for sure in your task and I will finish it in the required time. Thanks.

$30 USD in 1 day
(4 Reviews)
3.7
SusanTeke

Hi there! I''m experienced and skilled in MS Excel, having used this application extensively to manage a large educational institution. I'll be able to clean up your client data as you require. Karen

$120 USD in 5 days
(6 Reviews)
2.8
CreateMeNow

Hello. I hope that you are doing well today. I was reading through your post, and thought that I would help you with your project. My name is Russell, I am an expert and organizing spreadsheets. I would suggest that I More

$140 USD in 3 days
(1 Review)
2.5
jbayton2492

Hello there, As a Data Scientist I have huge experience working with several tools / techniques like: - Web Scraping - Python Programming - Vba Code (Macros, Graphs and Dashboards) - Machine Learning (Models, Data More

$40 USD in 5 days
(1 Review)
2.0
santosrafa021

Hi, i saw your project and i will be with accuracy and qualite. I can do this fast! Please send me a message and will be discuss more about your project.

$70 USD in 3 days
(3 Reviews)
1.2