title: "Flatten" multiple rows containing different data but with a common reference into a single row
body: <p>I've tried searching Stackoverflow and Google for an answer to this but haven't found it yet. I think part of my problem is I'm not sure what the keyword(s) for what I'm trying to do would be.</p>
  
  <p>My data looks something like this:</p>
  
  <pre><code>ID    Var1    Var2    Name
  01    0001    0002    Bill
  01    0001    0002    Jim
  01    0001    0002    Sally
  02    0003    0004    Sam
  02    0003    0004    Kyle
  </code></pre>
  
  <p>You'll see that I have multiple rows with the same ID and same Var1 and Var2 but each row has a unique name. I want to "flatten" the rows so there is only a single row for each ID and each row has as many "Name" columns as are necessary to fit all of the data. </p>
  
  <p>Like this:</p>
  
  <pre><code>ID    Var1    Var2    Name1    Name2    Name3
  01    0001    0002    Bill     Jim      Sally
  02    0003    0004    Sam      Kyle
  </code></pre>
  
  <p>Does anyone know how to do this or what it's called?</p>
  
  <p>Thanks!</p>
  
  <p>Update based on comments: 
  My data source is .csv file and I'm trying to manipulate it with Excel. Excel macros or VBA solutions would be best. Unfortunately my SQL is very elementary so learning to apply an SQL solution would be time-prohibitive.</p>