title: How can I display unique names in Excel?
body: <p>Given the following table on sheet one:</p>
  
  <pre><code>Name
  -------
  Alan
  Barb
  Corey
  Barb
  Alan
  Daniel
  Alan
  </code></pre>
  
  <p>How can I generate the following table on sheet two?</p>
  
  <pre><code>Name
  -------
  Alan
  Barb
  Corey
  Daniel
  </code></pre>
  
  <p>I cannot leave empty rows like this:</p>
  
  <pre><code>Name
  -------
  Alan
  Barb
  Corey
  
  
  Daniel
  </code></pre>