title: Pivot Header Data in row using sql server
body: <p>Is there any way to make table pivot in sql server like such a way.</p>
  
  <p>I have data like </p>
  
  <pre><code>| OldItem | NewItem |
  ---------------------
  |   HD1   |   365   |
  </code></pre>
  
  <p>I need output like below.</p>
  
  <pre><code>|    Name     | Value1 |
  ---------------------
  |   OldItem   |   HD1  |
  |   NewItem   |   365  |
  </code></pre>
  
  <p>Thanks in advance.</p>