I have table below:

```
Account.Code    Brand       
1600    Sensodyne TP        
1600    Sensodyne TP        
1600    Zem     
1600    Sensodyne TP        
1800    Sensodyne TP        
1800    Burb MN     
1800    Burb MN     
2000    Lami        
2000    Lami        

```

How do I transform to table like below:

```
Account.Code    Brand   Count
1600    Sensodyne TP    3
1600    Zem             1
1800    Sensodyne TP    1
1800    Burb MN         2
2000    Lami            2

```

I would need to do this a much larger data set, shown is just a simple example.