title: How to Convert Columns to Rows in Sql Server 2008 R2?
body: <p>I have a table like this</p>
  
  <p><img src="https://i.stack.imgur.com/NCUCH.png" alt="enter image description here"></p>
  
  <p>and the result should be like this</p>
  
  <p><img src="https://i.stack.imgur.com/BcEGc.png" alt="enter image description here"></p>
  
  <p>i am little bit confused about Pivot and unpivot and cross apply. can anyone help me from this.</p>