Merge/Combine Rows Help
Results 1 to 4 of 4

Thread: Merge/Combine Rows Help
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Merge/Combine Rows Help

    Hello! looking for some help.

    I have a sheet with over 2000 rows, some duplicates, some not. I am after a way to quickly edit the sheet to achieve a few things:

    1 row entry for each unique item - combine the information (If info is present) in columns E, F, G & H for the row.

    Here is what I have:

    https://postimg.cc/fksFMn2R

    Here is what I am trying to achieve:

    https://postimg.cc/PpXRz188

    Thank you so much for your help, let me know if i can provide any more information.

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,676
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Merge/Combine Rows Help

    try PowerQuery (Get&Transform) with Group feature and SUM option for values
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  3. #3
    Board Regular Sam_D_Ben's Avatar
    Join Date
    Oct 2012
    Location
    New Jersey, USA
    Posts
    371
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Merge/Combine Rows Help

    May be something like this. You can modify the formula, just giving you an idea.

    Excel 2013/2016
    ABCDEFGHIJK
    1Item NoItem NameItem DescrptionsCategoryUnits on HoldItem NoItem NameItem DescrptionsCategoryUnits on Hold
    2P001*Product 1"Item DescrptionsCategory0P001*Product 1"Item DescrptionsCategory1
    3P001*Product 1"Item DescrptionsCategory1P002*Product 2"Item DescrptionsCategory1
    4P002*Product 2"Item DescrptionsCategory0
    5p002*Product 2"Item DescrptionsCategory1

    Sheet1



    Worksheet Formulas
    CellFormula
    K2=SUMIFS($E$2:$E$5,$B$2:$B$5,H2)

    Sam_D_Ben

  4. #4
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,681
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Merge/Combine Rows Help

    Do the duplicates always have a zero value in cols "F" & "G" ??
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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