title: Excel: transpose rows to columns and merge
body: <p>I would like to present some data in Excel in a table. I have a sheet with three columns: date, time_spent and user_id. Every row is a data record. I want a table with a column for every date and every value with time spent below the date.</p>
  
  <p>Using the transpose function under paste special I get this:
  <a href="https://i.stack.imgur.com/rNUZA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rNUZA.png" alt="Using the transpose function under paste special I get this:"></a></p>
  
  <p>However I would like only one column per unique date, so the amount of columns decrease like this:</p>
  
  <p><a href="https://i.stack.imgur.com/UWsGF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UWsGF.png" alt="enter image description here"></a></p>
  
  <p>Does someone know how to do this?\
  I have more than 10000 rows, so manually is too much effort...</p>
  
  <p>Using Pivot Tables as Tim Biegeleisen suggested I cannot get what I want either, I'm not an expierenced user of Pivot Tables so probably I'm doing something wrong:</p>
  
  <p><a href="https://i.stack.imgur.com/DcOel.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DcOel.png" alt="enter image description here"></a></p>
  
  <p><a href="http://robabeling.com/download/stackoverflow.xlsx" rel="nofollow noreferrer">Excel file as shown in above picture</a></p>