title: Merging two excel rows that have same data or differing data in columns
body: <p>I have the following issue in excel.  I have a spreadsheet with data sorted by Visit ID and would like to combine the rows that have the same Visit ID.  The problem is this:</p>
  
  <p>12345      value (column1)   value (column2) value(column3) </p>
  
  <p>12345 no value (column 1) value (column2)  no value (column3)  </p>
  
  <p>The rows have columns that are either in common with the same value
  or they have columns where one row has the information and the other has a blank.</p>
  
  <p>How do I merge 12345 IDs to have all columns populated?
  Thanks!</p>