Cancelado

DataBase / Excel Help

I have about 32000 records in an excel file. Each record has about 15 columns.

About 12000 records are duplicate and a few records even appears 3 times. I can remove the duplicates by sorting the records by "name feild" and then find duplicates by formulas.

But, the problem is that in the duplicate records, the other 15 feilds are not same for all duplicates.

For eg.

Cell number A1 and A2 are duplicate, But Cell A1, A2...and B1, B2 are not same. Some data is in row A and some data is in Row B.

I need help in merging those records. For eg. if Row A1 is blank and B1 has the data, then I need the B1 data merged into A1. If both feilds have data, then I need data combined from both feilds.

This should be very easy who know the excel and database things.

Once this is done, I may also need you to do a cleanup with the database and convert to mysql format. But, this will be another project.

Let me know if you don't understand anything. Easy $30 for someone who is capable.

Habilidades: .NET, Excel, MySQL, SQL, Visual Basic

Ver más: need someone to do a excel project, Need help in excel, me excel, i need help with excel, i need excel help, help find , find help, need help with excel, need help excel, need excel help, a1, row b, help name, help me find a name, happy2help, format excel, Excel Formulas, excel duplicate, excel data sorting, do excel, Convert Database, b2, excel database visual basic, easy database project, remove duplicates mysql

Información del empleador:
( 62 comentarios ) Chandigarh, India

ID de proyecto: #693858

101 los freelancers están ofertando un promedio de $39 para este trabajo.

HussienSharaf

Hi, i m expert in Excel and Access Regards, Hussien Sharaf

$30 USD en 1 día
(61 comentarios)
7.1
srinichal

I can deliver the project

$40 USD en 2 días
(93 comentarios)
7.0
MMaghawry

easy to be done , let me do it.

$30 USD en 0 días
(112 comentarios)
6.8
MAnkita

Hello,I can do this for [url removed, login to view] you.Ankita.

$50 USD en 2 días
(103 comentarios)
6.8
vserv

Pls see your PMB. Thanks

$30 USD en 2 días
(73 comentarios)
5.9
nsurani

We have both passion & expertise to do the same within specified time & budget.

$30 USD en 0 días
(22 comentarios)
5.7
nagybatonyi

Such jobs are my daily practice, please see PMB for details! Regards!

$30 USD en 0 días
(53 comentarios)
5.7
binaryromel

Pls, chk inbox

$30 USD en 2 días
(66 comentarios)
5.7
MustafaSR

Hi, This project is easy, but not worth doing for $30, I can solve all the duplicates in 32000 records, but will charge $70 for it.

$70 USD en 5 días
(54 comentarios)
5.5
vbexcel

Please refer to PMB for more information.

$30 USD en 0 días
(30 comentarios)
5.5
djucuti

Hi, please see PM

$30 USD en 1 día
(22 comentarios)
5.3
serge2

please see pmb

$35 USD en 1 día
(4 comentarios)
5.2
agihcam

Please check PMB.

$30 USD en 1 día
(39 comentarios)
5.2
indivar

Hi, Kindly have a look at PM for detailed proposal. Inderjeet singh

$30 USD en 0 días
(2 comentarios)
5.2
piyushdpatel

Hi This is Piyush Patel I have 5 yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM

$35 USD en 1 día
(17 comentarios)
5.0
GFsoul

hello sir i can do you work just in 20-25 min i have done this work many times and then what u like u give me i just need your reviews please give my one change

$30 USD en 1 día
(27 comentarios)
5.0
SmartGuru

Hello, I will be glad to take up the Excel job. Please check your private message for further details of my bid. Kind regards.

$30 USD en 1 día
(29 comentarios)
4.8
eagle2k13

I can get this done for you quickly. I look forward to working with you!

$30 USD en 1 día
(17 comentarios)
4.8
florinserban

Hi. Please check PM. Thanks!

$30 USD en 1 día
(11 comentarios)
4.6
freddyho

Please see your PMB

$30 USD en 0 días
(9 comentarios)
4.1