title: SQL Server 2005, turn columns into rows
body: <p>I am trying to turn a table 90 degrees: make columns rows.  No PIVOT is allowed since PIVOT requires aggregate functions.  </p>
  
  <p>Example: 
  I have a table with the columns:<br>
  ID int,<br>
  ISO char(2),<br>
  Text varchar(255). </p>
  
  <p>So I have this:</p>
  
  <pre>
  ID ISO Text
  -- --- ----
   1 DE  Auto
   2 EN  Car
  </pre>
  
  <p>I'd like to get the following:</p>
  
  <pre>
  ID EN  DE
  -- --- ----
   1 Car Auto
  </pre>
  
  <p>How do you accomplish that?</p>