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
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
Not had a look at your file yet but it sounds like something that could easily be done with a pivot table.
ASKER
Unfortunately, I can't have tables in this spreadsheet.
Thanks!
Thanks!
Why do you have blank columns in your data?
ASKER
Data is exported from a program that for some reason has blank rows & columns.
I can remove those before trying to merge this data.
I can remove those before trying to merge this data.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That worked perfectly!
Thanks!
Thanks!
You're welcome!
ASKER
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. :)
ASKER
Great!
Thanks again.
Thanks again.
You're welcome again! :)