Combine multiple rows into one row
Hello,
I need to combine data from multiple rows into one row. I feel like I've tried everything I know, from merging to various formulas, and I downloaded a merge add-in, all to no avail. My worksheet has over 6,000 lines and I'm desperate to get this done. Your help is greatly appreciated!
I've attached a sample worksheet with an example of my problem and how I'd like it to look when complete. Thanks!
KelMel,
Attached is a modified version of your example workbook. It contains a button named "Combine" which is assigned to the following macro:
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Wow! You rock. You have no idea how much time you saved me. Thank you!!!
Oops. Macro not working.
Last edited by KelMel; 12-08-2011 at 02:21 PM.
Attachment for tigeravatar
tigeravatar, here is the attachment to use. The last one didn't have any duplicates. Dumb. Sorry.
KelMel,
Modifed code so that it uses combined first name & last name to determine duplicates instead of email addresses, and then it combines rows based on that, give it a try:
Please Login or Register to view this content.
SOLVED!
It looks like I am all set! Thank you again!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks