title: SQL multiple characteristics in one line
body: <p>I have a question regarding how to merge lines with same characteristics:</p>
  
  <p>I have this data:</p>
  
  <blockquote>
    <p><code>Client | Product  | Date</code></p>
    
    <p><code>Hannah |   TV     | 1 Jan</code></p>
    
    <p><code>Tom    | Laptop   | 3 Feb</code></p>
    
    <p><code>Peter  | iPod     | 2 Jan</code></p>
    
    <p><code>Hannah | Laptop   | 5 Feb</code></p>
    
    <p><code>Tom    | iPod     | 5 Feb</code></p>
  </blockquote>
  
  <p>And I want to create this:</p>
  
  <blockquote>
    <p><code>Client | Product-History|</code></p>
    
    <p><code>Hanna  | TV-Laptop      |</code></p>
    
    <p><code>Tom    | Laptop-iPod    |</code></p>
    
    <p><code>Peter  | iPod           |</code></p>
  </blockquote>
  
  <p>Anyone know if this is possible in SQL?</p>
  
  <p>If you require actual SQL code to make it easier to respond let me know, it's the first time I ask a question.</p>
  
  <p>Thanks!</p>
  
  <p>Edit: I am using SQL Server</p>