title: How transpose rows to columns in SQL query with specific content from row?
body: <p>I have db with a structure like that - <a href="https://dbfiddle.uk/?rdbms=sqlserver_2014&amp;fiddle=d6fbba16eed4fec7452bcc07b5f82edd" rel="nofollow noreferrer">dbfiddle</a></p>
  
  <p><a href="https://i.stack.imgur.com/CYMQq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CYMQq.png" alt="enter image description here"></a></p>
  
  <p>As a result, I would like to get:</p>
  
  <pre><code>          Question1  Question2   Question3
  User 1    Answer1    Answer2     Answer3
  User 2    Answer1    Answer2     null
  User 3    Answer1    Answer2     null
  User 4    Answer1    null        null
  </code></pre>
  
  <p>And I need to have option to choose questions which will be shown. For example only 1 and 3. </p>
  
  <pre><code>          Question1  Question3
  User 1    Answer1    Answer3
  User 2    Answer1    null
  User 3    Answer1    null
  User 4    Answer1    null
  User 5    Answer1    Answer3
  </code></pre>
  
  <p>Can you please help me to write down SQL query for this? </p>