如何在SQL Server 2005中进行sql表的尴尬转移？

I have to rotate a given table from an SQL Server but a normal pivot just doesn't work (as far as i tried). So has anybody an idea how to rotate the table into the desired format?I have to rotate a given table from an SQL Serv