title: SQL Rows to Columns
body: <p>I have a table and want to transpose its rows to columns, similar to a pivot table but without summarising.</p>
  
  <p>For example I have the following tables:</p>
  
  <pre><code>Question
  --QuestionID
  --QuestionText
  
  Response
  --ResponseID
  --ResponseText
  --QuestionID
  </code></pre>
  
  <p>Basically I want to be able to create a dynamic table something like:</p>
  
  <pre><code>Question 1 Text | Question 2 Text | Question 3 Text
  ---------------------------------------------------
  Response 1.1 Text | Response Text 1.2 | Response 1.3
  Response 2.1 Text | Response Text 2.2 | Response 2.3
  Response 3.1 Text | Response Text 3.2 | Response 3.3
  Response 4.1 Text | Response Text 4.2 | Response 4.3
  </code></pre>
  
  <p>The main requirement would be I don't know at design time what the question text will be.</p>
  
  <p>Please can someone help - I am pulling my hair out :oS</p>
  
  <p>Essentially you can guarantee that there will be a response for each corresponding question in this scenario.</p>