I have a DB that has the following table

ITEM COLOR
Hat Red
Hat Red
Hat Blue
Hat Orange
Belt Red
Belt Blue
Belt Blue
Belt Orange

I want to query and display results like this:
ITEM - Red - Blue - Orange
Hat - 2 - 1 - 1
Belt - 1 - 2 - 1

Any help is greatly appreciated