I have this data about brands and sellers.

enter image description here

I want to transform it into this type of table – so actually I just need to count different types of sellers

Brand | Amazon | 3rd party |

Chanel | 6 | 10 |

I tried this code – but numbers in count are strange

enter image description here