• Yes, you could do this, by using the PIVOT statement. For syntax and usage of this keyword refer Books Online.

    Cheers.