title: Code to move multiple rows and columns into singular row with multiple columns
body: <p>I'm looking for a piece of code that I can use to move data in Excel from multiple rows into one row based on it having the same id in column 1. See example data below:</p>
  
  <pre><code>Column1 Column2 Column3 Column4
  11111   Axx/111     
  11111           Bxx/111 
  11111                   Cxx/000
  22222   Axx/112     
  22222           Bxx/444 
  22222                   Cxx/111
  33333   Axx/113     
  33333           Bxx/555 
  33333                   Cxx/222
  44444   Axx/114     
  44444           Bxx/666 
  44444                   Cxx/333
  55555   Axx/115     
  55555           Bxx/777 
  55555                   Cxx/444
  </code></pre>
  
  <p>Where the reference in column 1 is the same for multiple rows I want to move the data from the multiple columns, keep it in columns but have it all referenced in 1 row. So instead of  this:</p>
  
  <pre><code>Column1 Column2 Column3 Column4
  11111   Axx/111     
  11111           Bxx/111 
  11111                   Cxx/000
  </code></pre>
  
  <p>I get this:</p>
  
  <pre><code>Column1 Column2 Column3 Column4
  11111   Axx/111 Bxx/111 Cxx/000
  11111           
  11111   
  </code></pre>
  
  <p>or this:</p>
  
  <pre><code>Column1 Column2 Column3 Column4
  11111   Axx/111 Bxx/111 Cxx/000
  11111   Axx/111 Bxx/111 Cxx/000
  11111   Axx/111 Bxx/111 Cxx/000
  </code></pre>
  
  <p>Please help!</p>