Link to home
Start Free TrialLog in
Avatar of Sasha2016
Sasha2016

asked on

Combine and sum duplicate rows

How to combine duplicate rows, if values in two columns are identical....and sum qty from third column:
Sample file attached, but here's the jist of it:
          B             D           F
      Frame    White    100
      Frame    White    200

        to show one line:
      Frame    White    300

Can this be done with formula or VBA?
Rows are not adjacent...can be spread out throughout the spreadsheet (if it matters, it's fairly small sheet...never has more than 50 rows)

Thanks!
sample.xlsx
Avatar of Norie
Norie

Not had a look at your file yet but it sounds like something that could easily be done with a pivot table.
Avatar of Sasha2016

ASKER

Unfortunately, I can't have tables in this spreadsheet.
Thanks!
Why do you have blank columns in your data?
Data is exported from a program that for some reason has blank rows & columns.
I can remove those before trying to merge this data.
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
That worked perfectly!
Thanks!
You're welcome!
Hope this shows up...not sure how to assign points (or does "recognize experts" slider automatically does that?)
Yes, that is fixed now. Thanks for your time to fix this. :)
Great!
Thanks again.
You're welcome again! :)