How to sum up values by ID

I want to sum the values in column B so that I only got displayed the IDs once and the sum of the regarding values. Here is a screenshot from what I mean:

I would expect to have a row with ID 111 and value 9

Thats for →Data→Pivottable...

You could create a pivottable or you could use the SUMIF function to accomplish what you describe.