In Progress

Data Formatting and Duplicate Data Merging

We are doing some migration into a new system and discovered we have a lot of duplicate data on the old system see the attachment that best describes what the data looks like.

We now have a clean record on our new database after asking people to re-register

but will like to import and match contribution records from the old system into the new system one matching the right person record.

we have about 14000 people record on the old system

and about 2000 records on the new system

we are looking for a freelancer that can use an automated tool or script to go through the new people record and find all matching contribution records in the old data.

both files will be given in csv format

the expected delivery will be a csv or excel file with contribution records with duplicates merged and containing the right email and name

The Project will be divided into two phases

Phase 1

Help Format Data collected from google sheets into format for new system

Phase 2

Do data clean up of contribution data as outline above

Skills: Data Entry, Data Processing, Database Administration, Excel, VBScript

See more: Data Entry any type Data Mining Web Research RETYPE Scanned/PDF Files Office Work (Word, Excel, PowerPoint, PDF,, merging data excel word 2010, data merging, vba form displays duplicate data excel, data merging cleaning, merging data word, create data access layer use linq sql nhibernate, network data drives clean script, data entry clean work, merging data processing, duplicate data phpmysql, duplicate data entry mysql php, access error duplicate data change data field, excel script duplicate data, duplicate data mysql, duplicate data database php, search data php mysql use date range, formatting numbers data sheet view, combine sheets remove duplicate data, formatting nsso data stata

About the Employer:
( 6 reviews ) Laurel, United States

Project ID: #16635194

Awarded to:

ujjwalmalik

Hi There, I have understood your requirements. I am a professional in data cleansing & data migration. I have helped many clients previously to clean their data with 100% accuracy. Can I please see the attachment I More

$250 USD in 3 days
(60 Reviews)
6.0
arranmercer

I will complete the project as discussed over chat. The project will be 2 phases, the first of which will be completed by Sunday.

$250 USD in 4 days
(12 Reviews)
4.1

15 freelancers are bidding on average $243 for this job

$300 USD in 5 days
(231 Reviews)
7.4
P0L

Hello, I’m an Excel expert and I would like to help you with your project. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards.

$350 USD in 5 days
(275 Reviews)
7.1
ksriniravi

Attachment missing! Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on developing macros every single day. I understand the requirements and can come up with the requir More

$200 USD in 5 days
(143 Reviews)
6.5
tanjirdramatist

Dear Sir, I have read your job description & have understood your all requirement. I have also a big team to complete it earlier. After seeing my previous record, You will decide that I will be the right person More

$388 USD in 10 days
(153 Reviews)
5.8
Imranatmoon

HI There, I have over 18 years experience in admin data entry. Available and ready to start. please share csv/excel file Regards Imran

$150 USD in 10 days
(42 Reviews)
5.0
bhosale21sachin

Hi there, I am interested in this project. I am a freelancer worked in data entry (speed 60 wpm), customer service, and web research tasks. I found your job in-line with my experience and hence I would be happy More

$124 USD in 5 days
(23 Reviews)
4.6
$333 USD in 10 days
(25 Reviews)
4.2
mrherkar

Hi there, I could develop/customize an .NET application to filter your data. I have a CSV library so I'm sure I could do this project.

$250 USD in 7 days
(4 Reviews)
3.5
RAZAQ786

hi,sir/madam I am providing All types of Online and Offline Data Entry, Web Research Jobs. Whether you need an enthusiastic Virtual Assistant or Office Admin Support I'm very willing to work with you. I'm fully capabl More

$111 USD in 10 days
(1 Review)
2.4
SSaha1999

i can do it within one day. as a CSE (computer science) student excels learning is mandatory for me. so i can make a script so that i can find duplicate data in your CSV file. i think i need 2-3 hour to perfectly do y More

$100 USD in 1 day
(4 Reviews)
1.9
$277 USD in 8 days
(0 Reviews)
0.0
mafzz786

Hi, I have data entry experience since 3 years. I m here to provide best and fastest services regarding all type of offline and online data entry, internet search and data mining. i am very accurate typist at a speed o More

$222 USD in 10 days
(0 Reviews)
0.0
$333 USD in 10 days
(0 Reviews)
0.0