How to get row data in columns and column data in rows using pivot in sql 2008 r2 : [Current result which i am getting from my stored procedure][1]


[Expected result from current result][2]


  [1]: http://i.stack.imgur.com/S8zxt.jpg
  [2]: http://i.stack.imgur.com/L1OtK.jpg