title: How to convert multiple columns into a single row with row number?
body: <p>I'm trying to figure out a way to convert 
  [Column1],[Column2],[Column3],[Column4],[Column5] into a single column [Type]. I also want it to have row number. So an example of how I would want it to look like. ALso, what if I just want column with data to output? Like Column1 and Column2 both have values but column3, 4, and 5 don't. In this case, I just want 1 and 2 to show on my resultset.</p>
  
  <p>Now:</p>
  
  <pre><code>[ID1]-[Column1],[Column2],[Column3],[Column4],[Column5]
  
  [ID2]-[Column1],[Column2],[Column3],[Column4],[Column5]
  </code></pre>
  
  <p>Desire: </p>
  
  <pre><code>[ID1]-[Column1],[Row1]
  
  [ID1]-[Column2],[Row2]
  
  [ID1]-[Column3],[Row3]
  
  [ID1]-[Column4],[Row4]
  
  [ID1]-[Column5],[Row5]
  
  [ID2]-[Column1],[Row1]
  
  [ID2]-[Column2],[Row2]
  
  Etc......
  </code></pre>
  
  <p>Thank you!</p>