title: Excel 2010 moving data from 1 row to another if 1 cell is duplicate
body: <p>I have a spreadsheet with various columns. Column 1 is a telephone number, another is a text field. However the telephone number can be repeated but the information in other field is unique.</p>
  
  <p>For example</p>
  
  <pre><code>Column 1    Column 2  
  11111111    A  
  11111111    B  
  11111111    777  
  22222222    B  
  22222222    C  
  </code></pre>
  
  <p>Would like output to be:</p>
  
  <pre><code>Column 1    Column 2    Column 3    Column 4  
  11111111     A           B           777  
  22222222     B           C
  </code></pre>
  
  <p>Any ideas?</p>
  
  <p>Any help is much appreaciated </p>