It's static data, results of a survey. I kind of just had a brain freeze, had a lot of cleaning to do while I was formatting the data.

I'm sure there's a better way to do it but I've just extracted the first 4 characters into a new column then sorted/subtotalled them. I need the first 4 characters (numbers and letters)