I've got an existing worksheet (items_sold) with 2 columns.

Column A has an item description (eg Item 1, Item 2, Item 3). The items are
repeated througout the list. Column B has the number sold of each item.

eg

Item 1 6
Item 2 12
Item 1 3
Item 3 3

I'd like to create a new worksheet where column A is a list of each item
that appears in items_sold (but with no repeats) and column B is the total
of items sold. eg

Item 1 9
Item 2 12
Item 3 3


Can SKS help


TIA


Rob