Käynnissä

Excel data conversion, cleaning and sorting + Web download

This project involves converting data from a column block address to a row format by highlighting block, copy paste, transpose....then drop correct data into correct fields (tel, fax, email, etc...)

There are five data files that need cleaning in this way, but on most of them, some of the data is already cleaned to show the layout.

One of the files (DFL Sample Data) has a second tab that has links to websites to download data, and then convert it to the format required. This file can probably use macro formulas to set the data into correct fields.

On all files, where there are multiple contacts for an address / company, then the address line will need to be duplicated.

each file will need to be returned as soon as it is completed.

Feedback and payment will be provided on final file return.

All files except the DFL file (sample only) are the final files submitted for work.

Thank you.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel

Näytä lisää: set data, sample thank email, data entry macro, block company, cleaning sorting data, final data, correct email format, transpose, sample data, macro excel, format excel, file conversion, excel formulas, excel data sorting, excel data processing, data convert, copy excel, converting files format, convert excel web, Cleaning, cleaning company, multiple excel, excel macro download file, excel sample project data, excel file convert

About the Employer:
( 6 reviews ) Toronto, Canada

Projektin tunnus: #508034

Myönnetty käyttäjälle:

bkragul

Hi, Please Check Your PMB...

30 $ USD 1 päivässä
(15 arvostelua)
4.2

12 freelanceria on tarjonnut keskimäärin 64 $ tähän työhön

YourAssistant

Hi, here is my bid to express my interest in your project. Please read PM for further details …Thanks

100 $ USD 2 päivässä
(116 arvostelua)
6.2
lucky2gaf

Hi, please view my PM for details, thanks.

60 $ USD 1 päivässä
(107 arvostelua)
6.0
mohanlg

Hi, Ready to start work now. thanks sunny

150 $ USD 3 päivässä
(26 arvostelua)
4.3
FlashBack

Hello Sir I am ready to start immediately. hope to receive your considerations. Thanks Abir

55 $ USD 1 päivässä
(13 arvostelua)
3.9
loki1

Hey Mate, Please check PM for details. Cheers, Loki1

40 $ USD 1 päivässä
(7 arvostelua)
2.6
dynamicgroup007

************************** ((((( Hello I am ready to start right now,because i am very much interested. Please view my PM for details. ))))) **************************

30 $ USD 1 päivässä
(0 arvostelua)
0.0
tabbers20

I would like to work on your project. please

50 $ USD 1 päivässä
(0 arvostelua)
0.0
Chlorophilia

please check my pm

60 $ USD 1 päivässä
(0 arvostelua)
0.0
josephrowan

Hi, I can convert this data per your instructions. Thanks!

50 $ USD 1 päivässä
(0 arvostelua)
0.0
ekayes

Dear Sir, I am very much experienced on this works for over 12 years. I am ready to start the works as soon as I will get your clearance. Your satisfactory will be my pleasure. Regards, Emrul Kayes

45 $ USD 2 päivässä
(0 arvostelua)
0.0
zapsh

I can do it.

100 $ USD 30 päivässä
(0 arvostelua)
0.0