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

1. ## 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!

2. ## 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. ## 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. ## 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!!

5. ## 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.

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