New Excel user!
I have a large file with 75% duplicate entries.
For the duplicate entries, columns A-C are the same.
One entry is blank E-AD but has data AE-CP
Other entry is vice versa, data in E-AD but blank in AE-CP
How do I merge? Thank you kindly!
Why dont you attach a sample spreadsheet with dummy data? This will save us a lot of time while drafting out a solution for you.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thanks Arlette. Here's a sample of the thousands of rows I have in the spreadsheet. Please notice that I need to combine rows 1&2, 3&4, 6&7, but leave 5 and 8 alone as there is no duplicate for each.
I appreciate your time/effort
Last edited by kcemail2001; 01-16-2012 at 11:15 AM.
Your sample is not matching with your issue. Please fill up some more rows so we can clearly understand what to do.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
oops. so sorry. I hope this helps
For the duplicate entries, columns A-C are the same.
One entry is blank E-AD but has data AE-AP
Other entry is vice versa, data in E-AD but blank in AE-AP
I need to keep the non-duplicate entries.
Book13(2).xlsx
Was the attachment succesful? Any help is appreciated.
Thank you!
I checked your file (it was successful). However, what about rows 5 and 8, there are no double lines for these records. How should these be actioned?
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Yes, the non-duplicate rows (in this sample 5 & 8) need to be kept.
I could try to sort the entire list and initially remove the non-duplicate entries if that is necesary...
Hi,
If you are still interested, I think the Combine Rows Wizard for Excel add-in can automate the task. Basically it merges duplicate rows based on the selected key columns and pulls the rest of the information onto the same line. You can find out more if you use the link to the product page: http://www.ablebits.com/excel-combine-rows/index.php
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks