title: SQL Pivot for multiple columns in a row
body: <p>My table structure like </p>
  
  <pre><code>----------------------------------------------
  AccountNo | Ben1 | Ben2 | Ben3 | Ben4 | Type |
  ----------------------------------------------
  A1234     | xyz1 | xyz2 | xyz3 | xyz4 | P    |
  A1005     | pqr1 | pqr2 | pqr3 | pqr4 | C    |
  ----------------------------------------------
  </code></pre>
  
  <p>I need to pivot above table to </p>
  
  <pre><code>-------------------------
  AccountNo | Name | Type |
  -------------------------
  A1234     |xyz1  |  P   |
  A1234     |xyz2  |  P   |
  A1234     |xyz3  |  P   |
  A1234     |xyz4  |  P   |
  A1005     |pqr1  |  C   |
  A1005     |pqr2  |  C   |
  A1005     |pqr3  |  C   |
  A1005     |pqr4  |  C   |
  -------------------------
  </code></pre>
  
  <p>By an sql query how I pivot to get above result</p>