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.
101 freelancer bu iş için ortalamada 39$ teklif veriyor
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 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