title: Excel or SQL Server - Multiple columns to rows
body: <p>In Excel 2010 or Microsoft SQL Server 2012:</p>
  
  <p>I have a table that has an ID in column a, and then columns B through (C - MM) with locations.</p>
  
  <p>I want to have column A be all of the locations &amp; then column B be the ID.</p>
  
  <p>Any way I can figure out so far has been to transpose by hand.</p>
  
  <p>Any help would be greatly appreciated!</p>
  
  <p>Imaged added:  <a href="http://i61.tinypic.com/dhegpc.jpg" rel="nofollow">image</a></p>