title: T-SQL Multiple Rows to a Single Row
body: <p>I have data similar to the below</p>
  
  <pre><code>    Set        Cost        Times
      ----------------------------
      GHT        100         20
      GHA        80          30
      GHE        70          10
  </code></pre>
  
  <p>Sometimes there are more rows, sometimes there are less. What I would like pulled back, using the example above, is something like:</p>
  
  <pre><code>Col1     Col2     Col3     Col4     Col5      Col6     Col7     Col8     Col9
  -----------------------------------------------------------------------------
  GHT      100      20       GHA      80        30       GHE      70       10
  </code></pre>
  
  <p>Thanks in advance</p>
  
  <p>JJ</p>