Hi,
So I have a large sheet that contains 2 columns; one is components and the other is an inventory number. The components are repeated throughout the sheet. I can sort them and have all of the similar ones together, but I need a fast way to merge them while adding the values :
This:
Column A - Column B
x - 1
x - 2
x - 1
x - 4
y - 1
y - 5
y - 1
z - 1
z - 1
z - 1
Needs to become this:
Column A - Column B
x - 8
y - 7
z - 3
There are roughly 4000 rows in the sheet covering about 400 products so it'll take me a long time to do by hand. What is an easier way to accomplish this?
Thank you.
Bookmarks