Hello,

I have years of purchase data that I need to combine, and I am looking for a quick way of doing so. I have purchase descriptions in column A, and in column B is the number of that item that was purchased. Many of the entries in column A are identical, but are throughout the worksheet.

I am looking to combine the values in column B if the items in column A are exactly the same-does that make sense?

Thank you for any help