Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11

Thread: Merge rows without loosing content of certain columns

  1. #1

    Merge rows without loosing content of certain columns



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I have a table with about 10000 entries and 30 Columents. Each row has an ID where about 4000 rows have the same ID. These rows are exactly the same except 6 columns in which they have binary (empty or 1) information. I would like to merge duplicate rows and if one of them has a "1" in a certain column, the merged row shall also have a 1.

    How can I do that? I tried now for about 2 hours, but don't find a soluation. I tried by sorting a checking whether the next row has the same entry. However, since sometimes there are three rows which are the same except the binary value, this approach is not working. I am happy for any suggestions!!!!

    I also google alreay, however, not successfully. Maybe I am looking for the wrong thing.

    THANK YOU!!!

    Ernest

  2. #2
    Hi
    may you post the sheet so i can help you to do so?
    regarding the merge without losing data you can try using ASAP Utilities and it will do the trick with one single mouse click.

  3. #3
    Hi,

    I installed ASAP Utilities now, however, I only find a delete duplicate function, but no function which allows me to merge the data of the duplicate cells. Where do I find that?

  4. #4
    Quote Originally Posted by ernestaigner View Post
    Hi,

    I installed ASAP Utilities now, however, I only find a delete duplicate function, but no function which allows me to merge the data of the duplicate cells. Where do I find that?

  5. #5
    Hi,

    Here an Excel sheet with a few example rows. I would like to merge columns BH to BO. Column BP to BR show the duplicates. The ID is in Column BD.


    Thank you very much!!!
    Attached Files Attached Files

  6. #6
    Hi thank you!

    I have seen that, but this just merges all the rows I select, however I would like to merge only duplicate rows. Since the file is very long I cannot pick one by one.

  7. #7
    Do arrange or sort and then do the merge.

  8. #8
    Hi,

    thanks! I am using now an ablebits addon which does exactly what I want!

    However, Thankyou for your help! Ernest

  9. #9
    what is the link?
    is it free?

  10. #10

Page 1 of 2 1 2 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •