Thanks Jack for the link. I am actually looking for information on UNPIVOT.

I know there's a type in the header...