title: SQL multiple columns grouping in one row
body: <p>I have the following table in SQL</p>
  
  <pre><code>AL1 | AL2 | AL3 | ACB | LL1 | LL2 | LL3 | LCB  
  ------------------------------------------------
   1  |  2  |  3  |  4  |  5  |  6  |  7  |  8
  </code></pre>
  
  <p>I would like to convert it as </p>
  
  <pre><code>    | L1  | L2  | L3  | CB  
  -----------------------------
  A   |  1  |  2  |  3  |  4   
  L   |  5  |  6  |  7  |  8
  </code></pre>
  
  <p>Any help would be appreciated.</p>