title: How to transpose a query result in SQL Server (rows to columns)
body: <p>my query gives me a result as follows:</p>
  
  <p><a href="https://i.stack.imgur.com/7wvKv.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7wvKv.jpg" alt="initial query"></a></p>
  
  <p>so, i want to transform that result into this:</p>
  
  <p><a href="https://i.stack.imgur.com/ppME1.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ppME1.jpg" alt="query transformed"></a></p>
  
  <p>Note the crossing fields with NULL values.</p>