+ Reply to Thread
Results 1 to 5 of 5

Merge duplicate rows and merge the columns (approx 10 columns)

  1. #1
    Registered User
    Join Date
    08-02-2012
    Location
    Georgia, USA
    MS-Off Ver
    2010
    Posts
    30

    Merge duplicate rows and merge the columns (approx 10 columns)

    I have a spreadsheet that has many duplicate rows and the duplicate rows have different quantities in different months (columns) that I need to add together after the merge. In the end... No duplicate columuns and the quantities stay in the correct month column and be added together if/when needed.

    I attached an example of what I'm looking at. I know the basics of excel but this is a bit over my head. I appreciate any help at all.

    Thanks!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-31-2012
    Location
    cape cod
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Merge duplicate rows and merge the columns (approx 10 columns)

    Try =SUMPRODUCT(($A$3:$A$35=P3)*($C$3:$N$35)) then you won't have to merge the cells.

  3. #3
    Registered User
    Join Date
    08-02-2012
    Location
    Georgia, USA
    MS-Off Ver
    2010
    Posts
    30

    Re: Merge duplicate rows and merge the columns (approx 10 columns)

    Thanks for the quick response, tacape! I tried the formula but not quite sure if I used it correctly or not. I do need to merge the cells tho. I have to show the quantity of items that have sold each individual month. The reports we run always show 1 part number in two different places with different sales data (quantity and month sold) and I have to merge the two tables together and then get rid of the duplicates.
    Thanks!

  4. #4
    Registered User
    Join Date
    08-02-2012
    Location
    Georgia, USA
    MS-Off Ver
    2010
    Posts
    30

    Re: Merge duplicate rows and merge the columns (approx 10 columns)

    Im not sure if I'm explaining it correctly so I added to the attachment. Hope this helps. Thanks!!
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-31-2012
    Location
    cape cod
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Merge duplicate rows and merge the columns (approx 10 columns)

    =sumproduct(($a$4:$a$36=$o4)*($b$3=$p$3)*($b$4:$b$36))

    SAMPLE.xlsx I started it will do both.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1