MS Excel expert to split data across cells and remove duplicates

Concluído Postado há 7 anos Pago na entrega
Concluído Pago na entrega

IMPORTANT: Only respond if you are Excel expert.

See demo attached. This is just an extract from the file to be used.

Names Sheet:

Task 1: Remove Duplicate records. A duplicate is where Registered Service Provider AND Head Office AND Telephone values are the same. End result is to have a single record for each set of duplicates.

Task 2: Split address values in a single cell split into 5 cells of Address line 1, Address line 2, City, State, Postcode.

Task 3: Groups Tan

Remove Duplicates. A duplicate is where the Registered Service Provider AND the Group values are the same.

Goal is to have a single record for each Registered Service Provider and Group combination.

When bidding send a note saying "I am an excel expert" so I know you read the spec.

Excel

ID do Projeto: #13124632

Sobre o projeto

75 propostas Projeto remoto Ativo em há 7 anos

Concedido a:

vsprybhanu

"I am an excel expert" Hi, Experienced Excel Macro Developer. I have read your instructions carefully. I have developed an Excel VBA Program to Remove all duplicate records. Please send me message to get Mais

$60 AUD em 1 dia
(84 Comentários)
5.7

75 freelancers estão ofertando em média $92 nesse trabalho

TypingxpertRehan

i am an excel expert, ok sure, i understand, and in next few hours i will get this done with 100% accuracy you bet, please share me full file, the sample is all clear, thx

$126 AUD em 1 dia
(1195 Comentários)
9.1
FINGERRPRINT

I am an excel expert. Row 10 and 11 are duplicate in demo file, I can remove duplicate and split the address in 5 column and get you the spreadsheet accurately. Have done this many time before. Looking forward to work Mais

$105 AUD em 1 dia
(236 Comentários)
7.9
mantislin

Dear sir, I am scraping expert, I have did too many scraping projects, please check my reviews then you will know. Can you tell me more details? then I will provide example data/script for you. Thanks, Mais

$97 AUD in 2 dias
(187 Comentários)
7.3
BithiXpert

A proposal has not yet been provided

$100 AUD in 3 dias
(308 Comentários)
7.5
hatemfreelance4

“Budget and project period are flexible to meet to your requirement” I’m an Electrical Engineer. I am very interested in Web search and data input task and also i have a good experience in this field. I am responsib Mais

$83 AUD em 1 dia
(140 Comentários)
6.8
hdlong66

"I am an excel expert" Hello. I have completed 6 similar projects and would like to provide my service on this task. Kindly refer to my similar projects at https://www.freelancer.com/projects/Data-Entry-Excel/Merge-e Mais

$100 AUD in 3 dias
(145 Comentários)
6.9
Vasilchenko

Hello I am an excel expert. Lets work..............................................................................

$70 AUD em 1 dia
(69 Comentários)
6.6
robin1108

Dear Hiring Manager, I am an excel expert.I read your project description properly and I am able to complete it on your budget. I am ensuring you 100% valid quality service following your requirements. If you are no Mais

$155 AUD in 3 dias
(54 Comentários)
6.3
natalka503

I am an excel expert. When I`m starting with some project I`m doing my best. I`m precise, hard working person. I would like to work with you.

$133 AUD in 3 dias
(66 Comentários)
6.3
Ayo25

I am a statistician with advanced knowledge of microsoft excel. I have experience with data entry and statistical calculations.I work fast and deliver my projects on time. Looking forward to working with you. Thank yo Mais

$155 AUD in 3 dias
(11 Comentários)
5.9
FutureAp

I am an excel expert. (100% efficient work) I have 9 years of work experience in,Payroll management, Data Processing, Data Entry, Order Management, Web chat, Book keeping, and Email Management services. My typing sp Mais

$78 AUD em 1 dia
(16 Comentários)
5.8
vladimirmefremov

I have conducted similar tasks and even more advanced in my past engagements. I will use the MID and SEARCH functions to split the addresses into multiple fields and also sort functions to remove the duplicate values. Mais

$155 AUD in 3 dias
(9 Comentários)
5.7
standarditech

"I am an excel expert" Hi, I have taken a deep look on this project, and I am sure that we can work together. I have experienced in these kind of task. Please give me a chance to serve you and i will never let you dow Mais

$30 AUD em 1 dia
(78 Comentários)
5.4
Ashisjena2015

I am excel expert.

$30 AUD in 2 dias
(41 Comentários)
5.5
binitkumar200022

I am an excel expert. I can start to work now and complete at the earliest possible. Will work at your rate. Thanks, Binit

$30 AUD in 3 dias
(25 Comentários)
5.1
SayTechSolution

I am an excel expert We are running a small Business with our expert operators. We are providing cost effective and quality service to our clients since April 2015. We would like to work on this project. Let me know i Mais

$100 AUD in 3 dias
(41 Comentários)
5.5
AhmedMarzoq

"I am an excel expert" ـــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــ

$50 AUD em 1 dia
(24 Comentários)
5.0
suyashdhoot

Hi I am a very experienced statistician and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have d Mais

$250 AUD in 3 dias
(12 Comentários)
5.1
sonarkaushik

*** I am an excel expert Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Mais

$99 AUD em 1 dia
(43 Comentários)
5.6
privani

I am an excel expert Over the period of 10 years, I have done plenty of data cleaning which includes removing duplicate records and splitting and merging data. I checked out your file. I can definitely do this fo Mais

$40 AUD em 1 dia
(30 Comentários)
5.0