title: Transpose or unpivot columns of software into two columns
body: <p>I have a SQL 2008 table containing one row for each computer with many columns of software titles:</p>
  
  <pre><code>Computer      Col1        Col2        Col3          Col4
  PC1           Acrobat     Word        Excel
  PC2           Word        Access      
  PC3           Google
  PC4           Word        Excel       SQL2008       Maximizer
  </code></pre>
  
  <p>I would like to combine it in to two columns like this:</p>
  
  <pre><code>Computer        Software
  PC1             Acrobat
  PC1             Word
  PC1             Excel
  PC2             Word
  PC2             Access
  PC3             Google
  PC4             Word
  PC4             Excel
  PC4             SQL2008
  PC4             Maximizer
  </code></pre>
  
  <p>It's not an aggregate of the columns, so does unpivot or transpose work?</p>
  
  <p>Each row has from 1 to 32 columns of data.
  There are hundreds of different values for the software names.</p>