Закрыт

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.

Квалификация: Excel, Ввод данных, Обработка данных, Интеллектуальный анализ данных

Показать больше 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

О работодателе:
( 0 отзыв(-а, -ов) ) Northridge, United States

ID проекта: #23960315

32 фрилансеров(-а) в среднем готовы выполнить эту работу за $116

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 Больше

$200 USD за 2 дней(-я)
(751 отзывов(-а))
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 Больше

$125 USD за 2 дней(-я)
(417 отзывов(-а))
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 Больше

$140 USD за 3 дней(-я)
(356 отзывов(-а))
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 за 2 дней(-я)
(424 отзывов(-а))
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 Больше

$150 USD за 5 дней(-я)
(428 отзывов(-а))
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 за 1 день
(351 отзывов(-а))
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 за 3 дней(-я)
(239 отзывов(-а))
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 Больше

$100 USD за 1 день
(91 отзывов(-а))
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 за 7 дней(-я)
(162 отзывов(-а))
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 Больше

$250 USD за 4 дней(-я)
(131 отзывов(-а))
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 за 2 дней(-я)
(31 отзывов(-а))
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 Больше

$75 USD за 3 дней(-я)
(34 отзывов(-а))
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 Больше

$100 USD за 3 дней(-я)
(3 отзывов(-а))
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 Больше

$80 USD за 1 день
(10 отзывов(-а))
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 Больше

$30 USD за 1 день
(2 отзывов(-а))
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 за 1 день
(4 отзывов(-а))
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 за 5 дней(-я)
(6 отзывов(-а))
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 Больше

$140 USD за 3 дней(-я)
(1 отзыв)
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 Больше

$40 USD за 5 дней(-я)
(1 отзыв)
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 за 3 дней(-я)
(3 отзывов(-а))
1.2