title: How can I return unique values horizontally on Excel
body: <p>I have a table that looks like this from A1-A10</p>
  <pre><code>**Animal**
  Zebra
  Zebra
  Zebra
  Giraffe
  Giraffe
  Monkey
  Monkey
  Cat
  Cat
  </code></pre>
  <p>I want to return ONLY the unique values HORIZONTALLY in a row - and have them sorted alphabetically</p>
  <p>like this:</p>
  <pre><code>Cat   Giraffe   Monkey   Zebra
  </code></pre>
  <p>Currently I have this formula in D3: but this returns unique values vertically</p>
  <p>=IFERROR(LOOKUP(2, 1/(COUNTIF($D$2:D2, $A$2:$A$10)=0), $A$2:$A$10), &quot;&quot;)</p>
  <pre><code>Zebra
  Monkey
  Giraffe
  Cat
  </code></pre>