İptal Edildi

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.

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

Daha fazlasını gör: 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

İşveren Hakkında:
( 62 değerlendirme ) Chandigarh, India

Proje NO: #693858

Bu iş için 100 freelancer ortalamada $39 teklif veriyor

srinichal

I can deliver the project

in %bids___i_period_sub_35% gün içinde40%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(123 Değerlendirme)
7.2
MMaghawry

easy to be done , let me do it.

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(169 Değerlendirme)
7.1
HussienSharaf

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(63 Değerlendirme)
7.2
MAnkita

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

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(105 Değerlendirme)
7.0
vbexcel

Please refer to PMB for more information.

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(34 Değerlendirme)
5.6
binaryromel

Pls, chk inbox

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(89 Değerlendirme)
6.0
vserv

Pls see your PMB. Thanks

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(65 Değerlendirme)
5.9
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.

in %bids___i_period_sub_35% gün içinde70%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(58 Değerlendirme)
5.5
nagybatonyi

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

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(62 Değerlendirme)
5.7
nsurani

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

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(22 Değerlendirme)
5.7
agihcam

Please check PMB.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(39 Değerlendirme)
5.1
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(29 Değerlendirme)
5.2
serge2

please see pmb

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)
5.2
djucuti

Hi, please see PM

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(23 Değerlendirme)
5.3
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(29 Değerlendirme)
4.8
eagle2k13

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(17 Değerlendirme)
4.8
florinserban

Hi. Please check PM. Thanks!

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(12 Değerlendirme)
4.8
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(27 Değerlendirme)
5.0
sayli2

very simple for [url removed, login to view] in Excel and mySQL

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(39 Değerlendirme)
4.2
freddyho

Please see your PMB

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(9 Değerlendirme)
4.1