Data Cleansing & Enrichment
$10-100 USD
Pagado a la entrega
• I have 44 excel files all with the same structure that need to be consolidated into a single excel file – this excel file should be named “directory” and saved. I expect about 700K records on this file.
• I have another excel file named “aggregate” that contains about 500K records but with a different structure to the “directory” file to be created above.
• I want all data from the file named “directory” to be copied to the matching column within the file named “aggregate”. A new file should be created and named “combined” and the source column value for records should be “directory”. I expect the file “combined” to contain about 1.2m records.
• Perform the following tasks to enrich the data
o Sort by “name”
o Find duplicate “names”
o Update blank cell values in source row with values from different sources matching the same “name”.
o Flag duplicate rows – so they can be removed from file
o Make all data values capital letters
o Save “combined file” as “Enriched”
• Perform other cleansing based on validation rules provided during the project
• Finish
Nº del proyecto: #10945680
Sobre el proyecto
24 freelancers están ofertando un promedio de $77 por este trabajo
Hi, I am good at Excel and can perform activities as given. I would also like to know the new procedure required.
I did already similar project and i can share a link to you if needed. Hello, I'm Irnes, data entry and web research worker from Bosnia-Herzegovina. I'm here to find a good, paid job and prove my skills. I'm very s Más
With respect to this project I would like to present myself as a candidate for your consideration. I have more than 6 years of experience. I have successfully completed few projects for US clients which involved web sc Más
Hello This is Sourabh Gupta from New Delhi. I am an advanced VBA programmer and I am really interested in doing your job. I am among top 111 members at EXCEL FORUM,, with over 300 questions answered and 1000+ r Más
Hi! I can provide you with all the Excel operations on the large files you mentioned and I am willing to discuss further details. I can have it all done in a few hours!
hi dear hiring manager i'm an expert in excel work and a good typist so i'll wish to make perfect your project and finish it at right time without any errors thanks so much best regards
HI IM JEFF PETEZA FROM PHILIPPINES I'D LIKE TO WORK ON YOUR PROJECT TO APPLY MY SKILLS AND ABILITY ON THIS KIND OF WORK
besides having strong reading and writing skills you also possess an extensive knowledge of using the numeric keys and spreadsheet programs. Many of the clerical jobs are related to the data entry of the numerics or fi Más
Hi, I am excellent with excel and have been using it for a decade working on it day and night. You can easily send it to me to do. I am in need of extra money and so am doing it at a very reasonable cost in minimum Más
I have a lot of experience with excel. I work with data for 6 years. This project is perfect. Give me its please. Thanks.