title: SQL Query to transpose data
body: <p>I have the following table in SQL Server 2008:</p>
  
  <pre><code>ID  Type    Value
  6   A_Left  A
  6   B_Left  B
  6   C_Left  C
  6   D_Left  D
  6   E_Left  E
  6   A_Right A
  6   B_Right B
  6   C_Right C
  6   D_Right D
  6   E_Right E
  </code></pre>
  
  <p>And I need to get them grouped based on Value column like:</p>
  
  <pre><code>ID  Type    Type    Value
  6   A_Left  A_Right A
  6   B_Left  B_Right B
  6   C_Left  C_Right C
  6   D_Left  D_Right D
  6   E_Left  E_Right E
  </code></pre>
  
  <p>Is this possible? I am not getting exact terms on what such transpose is called to google.</p>