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.
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.
Bu iş için 100 freelancer ortalamada $39 teklif veriyor
Hello,I can do this for [url removed, login to view] you.Ankita.
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.
Such jobs are my daily practice, please see PMB for details! Regards!
We have both passion & expertise to do the same within specified time & budget.
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
Hello, I will be glad to take up the Excel job. Please check your private message for further details of my bid. Kind regards.
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
very simple for [url removed, login to view] in Excel and mySQL