Em Andamento

Excel expert - 2 databases into 1. Duplicates removed

I need an expert at Excel.

I have 2 files that i need put into 1 file, all duplicates removed. this is a mailing & telemarketing list so i need to remove all duplicate businesses/or addresses that appear twice. this would only take an expert a few mins.

Budget under $20. This is a quick job.

before the files are merged the following needs to be done.......

1. the [url removed, login to view] file needs the "state & postcode" column spit into 2 columns "state" & "postcode" just like impactlist1.xls.

2. The "std phone" & "phone number" column in [url removed, login to view] need to be merged into one column called "phone

3. The "std fax" & "fax number" into 1 column in [url removed, login to view] need to be merged into one column called "fax"

4. all columns must be the same before the merge of the 2 files and removal of duplications.

5. the file called [url removed, login to view] must be sorted via "category" and sorted into the following categories: (remove all of category "martial arts" and save in separate file.

Corporate Health Fitness

Employment and Careers

Exercise Equipment

Health Fitness Centre

Holistic Health

Life Coaching

Massage Therapy

Nutritional Supplements

Personal Training

Pilates

Weight Loss

Wellbeing Centre

Yoga

Martial Arts -(this category needs to be removed and saved in a new xls file before merging the 2 file as i don't require this in the final file).

once the martial arts category has been removed and the columns of both files are identical they can be merged and the duplicates removed.

Budget $20 or less. do not bid higher as you will not will the job

I will provide files to winning bidder. must have ratings and previous experience

Habilidades: Processamento de Dados, Processamento de dados

Ver mais: xls excel expert, weight loss fitness, weight loss and health, weight loss and fitness, telemarketing phone number list, telemarketing needs or needs, telemarketing employment, std list c, std list, quick careers, personal training careers, or employment, job ratings, fitness weight loss, fitness and weight loss, file excel expert, expert excel job, excel 0 to expert, excel &, entry careers, employment careers, data processing careers, data entry exercise, coaching expert, careers data entry

Acerca do Empregador:
( 73 comentários ) Newmarket, Australia

ID do Projeto: #146265

Premiar a:

StaciD930

Please see PM.

$30 USD em 1 dia
(23 Avaliações)
4.8

41 freelancers estão ofertando em média $32 para este trabalho

ggopi

I'm Gopi from India. Please check my PMB.

$30 USD in 2 dias
(217 Comentários)
6.6
nehasb

Can get it done in few hours. Ready to start now. My bid is 15 USD. Please check my PMB

$30 USD in 0 dias
(347 Comentários)
6.8
JordanEnt

Please check PM

$30 USD in 2 dias
(56 Comentários)
6.5
iasmumbai

You are assured of timely delivery without any excuses. For further details about me as well as my experience is being conveyed in PMB. I trust that the said information will be helpful in deciding my merit for awardin Mais

$30 USD in 2 dias
(122 Comentários)
5.6
garbar

Dear sir. i am ready to start the project from now. waiting for your response. regards, garbar

$30 USD em 1 dia
(71 Comentários)
6.2
Obialo

hi kindly see you pm. thanks

$30 USD em 1 dia
(26 Comentários)
5.8
SouthIndian

Plz. refer PMB. Tks.

$30 USD in 0 dias
(142 Comentários)
5.8
yousefla

Would be glad to provide you with my service. Regards,

$30 USD em 1 dia
(18 Comentários)
5.3
yahya07

Hi, Please see PM for details. Thank you.

$30 USD in 0 dias
(26 Comentários)
4.8
teamspirit01

Hi James. Best deal on PMB. Thanks!

$30 USD in 0 dias
(12 Comentários)
4.6
asaikiran1979

Hi, I can complete right away. See my PM. Thank you.

$30 USD in 0 dias
(45 Comentários)
4.9
stungscorpion

Hi, I can do this for you ! Please see PM. Thanks, stungscorpion

$30 USD em 1 dia
(26 Comentários)
4.2
Wonderer

Hi I can do it. Thanks.

$30 USD in 0 dias
(4 Comentários)
3.8
MustafaSR

Ready to work atonce. this is a hour or two job for me. My bid is $16. you can pay me through paypal or escrow. Mustfa.

$30 USD em 1 dia
(9 Comentários)
3.8
graphicaa

Hi, I am Expert in Excel i have done with in 2 hours i can start now Thanks Sebastian

$30 USD in 0 dias
(6 Comentários)
3.4
barber64127

This is a quick job that should take less than two hours. My bid is $20, paid through PayPal. I am an Excel expert with successfully completed college level courses to back up my skills. I look forward to hearing from Mais

$30 USD in 0 dias
(1 Comentário)
3.5
jtillis

I can do this easily.

$30 USD in 2 dias
(1 Comentário)
2.9
xlent82

Hello, Please Check pmb. Regards

$30 USD em 1 dia
(1 Comentário)
2.0
MichaelAParsons

Hi James, I have worked in Excel for years doing exactly this type of work. Would be happy to perfom this immediately. Thanks! Mike

$30 USD em 1 dia
(1 Comentário)
1.0
itpj

I am an experienced self employed professional doing the same kind of projects. I can return the work in 2 days. I can charge $20 no problems. Keep me in loop for further assignments too. Pl ensure i get $20 after Mais

$30 USD in 2 dias
(0 Comentários)
0.0