title: Excel duplicate rows logic
body: <p>Is there a way to get rid of duplicates ONLY if the next row has the same value.  </p>
  
  <p>Example:</p>
  
  <p>I have an excel document with Name and date of birth:</p>
  
  <pre><code>person1     
              01/01/01
              01/01/01
  person2     
              02/02/02
  person3     
              03/03/03
              03/03/03
              03/03/03
  </code></pre>
  
  <p>I have thousands of rows of data.  I cannot use "Remove Duplicates" functions because more than one person can have same date of birth.  Any idea how to fix this data so I can import it in SQL Server?</p>