Käynnissä

Clean data in excel pre format

I imported names and addresses into Excel from various sources. The data is in mixed formats, mainly in cell blocks and needs to be cleaned into appropriate rows by header. I have a few files that need cleansing. The main action will be to convert block address in rows and transpose it into a single column. From there, allocate the appropriate text to the header. Where multiple contacts are listed under the same address, create a second column with matching address details for the second contact and so on. the data samples shows examples.

I have manually cleaned many records myself, but need help to complete as I have other pending work that needs my attention.

Please provide your competitive bids for this work. Thank you.

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

Näytä lisää: sources format, formats excel, clean data excel, excel pre format, need help excel, need excel help, transpose, text format, format excel, data in, data convert, data cleansing, cleansing, clean my, clean files, multiple excel, cell names, excel convert text address, help data, excel format cell, excel cell format, excel cell, pre data, matching files excel, excel text rows

About the Employer:
( 6 reviews ) Toronto, Canada

Projektin tunnus: #502143

Myönnetty käyttäjälle:

bkragul

Please check PMB...

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

94 freelanceria on tarjonnut keskimäärin 56 $ tähän työhön

brtodi

I'm ready to take up this project please see my PM.

60 $ USD 3 päivässä
(23 arvostelua)
5.0
dataperfect

Hi, Pls refer ur PMB.

100 $ USD 3 päivässä
(6 arvostelua)
4.5
privani

How soon do u want it to be done? PM me please. Thank you :-)

30 $ USD 5 päivässä
(15 arvostelua)
4.4
dxpert

hi sir see my pm for details. thanks

30 $ USD 1 päivässä
(11 arvostelua)
3.7
excelmodeler

I am an expert in managing databases and developing user interfaces to master the customized search. I can complete this project within a time of 3 days. I can share some of my work before we start.

50 $ USD 3 päivässä
(1 arvostelu)
1.4
IJDataSolutions

Sir, I am an experienced freelancer having 3+ years of experience in this type of jobs and i am interested in doing this project. I guarantee you 100% accuracy and on time completion of the project. I agree to all of y Lisää

30 $ USD 5 päivässä
(4 arvostelua)
1.0
everjoseph

Dear Sir/Madam, Kindly check my PM. Thanks & Regards Joseph Manuel Raj J

30 $ USD 3 päivässä
(1 arvostelu)
0.0
janmenjay

Hi, Surely I will do it as per requirments with possibility of accuracy.

50 $ USD 4 päivässä
(0 arvostelua)
0.0
drem2121

plz see my pm.

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

Please, Check the PM.

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

I will provide high quality project that you needed.

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

I hope my conditions are optimun for you. its a job that needs some time and a structured work method, I can guarantee all of them as well as your total satisfaction by the end of the proyect. Hope to work with you.

60 $ USD 2 päivässä
(0 arvostelua)
0.0
tricey

I would like to do this project for you I can have it back to you in 2 days or less.

35 $ USD 2 päivässä
(0 arvostelua)
0.0
MZHF

You have provide additional 4 files. To complete this kind of excel sheets it will take one day per sheet. I'm charging $50 for 10 excel sheets.

50 $ USD 4 päivässä
(0 arvostelua)
0.0
sachdevasukhdev

I HAVE 15 YEARS EXPERIENCE WORKING WITH MSOFFICE WORD,EXCEL, POWERPOINT ETC. I HAVE MORE THAN 10 YEARS EXPERIENCE WORKING FOR ELECTRONIC DOCUMENTATION CENTRE OF A WELL REPUTED REAL ESTATE COMPANY IN INDIA AS DEPUTY MAN Lisää

250 $ USD 15 päivässä
(0 arvostelua)
0.0
santanupal2009

please refer to pmb

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

I can do the project @240$ in 5 days

249 $ USD 5 päivässä
(0 arvostelua)
0.0
Mehedi1206

Dear sir, I and my 5 computer consisted firm are experienced in data entry,data processing,excel. you can select my company for best quality & cheap cast. Thanks & Regards Mehedi

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

I work the government of Puerto Rico. What you I do on a daily basis. I can help you.

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

I can do this for you. I have quite a bit of experience in data scrubbing and could have in the time shown. Thanks!

250 $ USD 3 päivässä
(0 arvostelua)
0.0