title: Convert Columns into Rows - SQL Server studio Management 2008
body: <p>I have 3 IDS columns that have thds of different values. I am trying to convert them into rows. I have tried an Unpivot method to no success.</p>
  
  <pre><code> ID1     ID2     ID3
   12345   54321     53
   9954     8854     6565
   7844     54     
   8744
  </code></pre>
  
  <p>I woudld like my data to display in one column</p>
  
  <pre><code> IDS
   12345   
   54321     
   53
   9954     
   8854 
   ECT..     
  
   Sample code below
  
   SELECT * IDS
  </code></pre>
  
  <p>FROM #UNIQUE as U</p>
  
  <p>unpivot
   ( 
   for TaxIDS in ([id1],[id2],[id3])
   )as P   </p>
  
  <p>Any help would be appreciated...:)
   The more research I do the more I think unpivot is not the best route. </p>