From column to row

Transact-SQL
2

See JamesK's answer in this thread: Dynamic Pivots