title: How to PIVOT Column Headers - SQL Data
body: <p>I have a data set view that needs to be pivoted whereby the Column Headers for AMC1, AMC2, and AMC3 Will become Rows under LOB.  Here is the example of Orginal:</p>
  
  <pre><code> Qtr    Year    BU  BU_Description  P2A_Line       AMC1  AMC2   AMC3
   Q3 2013    B52100  52100 - UFC      L1_1          203    17     7
   Q3 2013    B52100  52100 - UFC      L1_2          -      -      -   
   Q3 2013    B52100  52100 - UFC      L1_3          123    113    -   
  </code></pre>
  
  <p>Here is the example of the End Result:</p>
  
  <pre><code> Qtr    Year    BU  BU_Description   LOB     L1_1   L1_2    PL1_3
    Q3    2013    B52100  52100 - UFC  AMC1    203     -       123 
    Q3    2013    B52100  52100 - UFC  AMC2    17      -       113 
    Q3    2013    B52100  52100 - UFC  AMC3    7       -       -   
  </code></pre>
  
  <p>Does anyone have a simplistic and relatively easy way to do this? The examples out there have too many variables to derive the answer.  Any help would be greatly appreciated?</p>