title: Grouping and transposing data in excel
body: <p>i'm trying to create an excel spreadsheet to be used to perform some basic "planning".</p>
  
  <p>In one sheet I have a list of couples:</p>
  
  <p><a href="https://i.stack.imgur.com/iPdZA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iPdZA.png" alt="spreeadsheet 1"></a></p>
  
  <p>In a separate sheet I need to rearrange such data in the following way:</p>
  
  <p><a href="https://i.stack.imgur.com/k7DIv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/k7DIv.png" alt="spreadsheet 2"></a></p>
  
  <p>So basically I need to group the items by week number and transpose the items associated with each week number horizontally.</p>
  
  <p>Does anyone know if this is feasible with excel?</p>