• You are asking for a PIVOT here. This might help: http://www.sqlservercentral.com/articles/T-SQL/63681/