You might want to leave presentation for a presenation tool rather than doing it with TSQL. For example you could use Excel Pivot Tables or a Reporting Services Matrix -...

Thanks Lutz, will check out the DynamicCrossTab link! Might be a good idea no normalize the tables further, especially since I'll probably need some more data columns in the (old)...