complex count if/vlookup/sumif with duplicates

Hi,

Here is an example of my raw data, and what I would like to achieve with formulas. I hope that you can help.

It's very simple data, but there is a lot of it and I'm sure there's a simple way of turning it into a neat table to analyse!

Appreciate all your help.

Thanks,

Marta