>I believe you are describing a cross tab. There are a few utilities in the download section that can be used.

I think so too and was hoping to have this capability native in SQL :)