I have a column that has multiple divisions (groups), and another column that
has the severity level for that particular item (could be 1,2,3).

Example

Group Severity
CAT 1
DOG 1
FISH 3
CAT 2
DOG 3
FISH 3
CAT 1
DOG 1
FISH 2

Now on a summary page I want to give the results like this

Animal Sev1 Sev2 Sev3
Dogs 2 0 1
CAT 2 1 0
FISH 0 1 3

Any suggestions on how to pull that into a summary page, I was thinking
Vlookup but it doesnt seem to do eveything I want.

Thanks in advance
--
Neall