title: How to have one row multiple columns instead of multiple rows
body: <p>I have the following data:</p>
  
  <p><a href="https://i.stack.imgur.com/7hJtT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7hJtT.png" alt="enter image description here"></a></p>
  
  <p>In SQL Server How can I have group by <code>weekdate</code> so I have only one row for each <code>weekdate</code>, example for the <code>weekdate</code> <strong>2015-11-14</strong>:</p>
  
  <p><a href="https://i.stack.imgur.com/JvEUq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JvEUq.png" alt="enter image description here"></a></p>
  
  <blockquote>
    <p>Any clue?</p>
  </blockquote>