title: TSQL PIVOT MULTIPLE COLUMNS
body: <p>I have the following table but unsure of whether it is possible to pivot this and retain all the labels.</p>
  
  <pre><code>RATIO               RESULT   SCORE   GRADE
  Current Ratio       1.294    60      Good
  Gearing Ratio       0.3384   70      Good
  Performance Ratio   0.0427   50      Satisfactory
  TOTAL               NULL     180     Good
  </code></pre>
  
  <p>I will admit to not being very good with the use of pivots, so after several attempts resulting in this output:</p>
  
  <pre><code>SELECT 'RESULT' AS 'Ratio'
    ,[Current Ratio] AS 'Current Ratio'
    ,[Gearing Ratio] AS 'Gearing Ratio'
    ,[Performance Ratio] AS 'Performance Ratio'
    ,[TOTAL] AS 'TOTAL'
  FROM
  (
    SELECT RATIO, RESULT 
    FROM GRAND_TOTALS
  ) AS SREC
  PIVOT 
  (
    MAX(RESULT) 
    FOR RATIO IN ([Current Ratio],[Gearing Ratio], [Performance Ratio], [TOTAL])
  ) AS PVT
  </code></pre>
  
  <p>This gives the result:</p>
  
  <pre><code>Ratio    Current Ratio   Gearing Ratio   Performance Ratio
  Result   1.294           0.3384          0.0427
  </code></pre>
  
  <p>I will admit to be feeling very stumped on what to do next to produce the result I need which is:</p>
  
  <pre><code>Ratio    Current Ratio   Gearing Ratio   Performance Ratio   TOTAL
  Result   1.294           0.3384          0.0427              NULL
  Score    60              70              50                  180
  Grade    Good            Good            Satisfactory        Good
  </code></pre>