Counting groups in a list

Attachment 199784Hi all, i have attached a file to better describe my issue, essentially I would like to count all the 'A's, all the 'B's and so on in the file and have the count next to it, so something like

A 6
B 3
D 5
F 1

In the file I uploaded I have column B as a count of the numbers, is there a way I could get just the final number for each letter, that would solve my problem. But if there is a simpler more elegant way then please let me know

Thanks