title: How to eliminate duplicate values in a row
body: <p>I have an Excel spreadsheet that contains customer id number, and all email addresses we've collected for said customer.  There is one row per customer, and close to 10,000 rows.  In most cases, there are multiple occurrences of the same email address.  I would like to consolidate the list of addresses per customer down to a unique list.  I find many helpful articles on how to get unique values from data that occurs in separate rows, but this task needs to get unique values from separate columns.</p>
  
  <p>I want to take this....</p>
  
  <pre><code>CustomerID | Email1              | Email2            | Email3            | Email4            | 
  --------------------------------------------------------------------------------
  12345      | myemail@example.com | example@gmail.com | example@gmail.com | myemail@example.com
  </code></pre>
  
  <p>and turn it into this...</p>
  
  <pre><code>CustomerID | Email1              | Email2            | Email3            | Email4            | 
  --------------------------------------------------------------------------------
  12345      | myemail@example.com | example@gmail.com |                   |                   |
  </code></pre>
  
  <p>Is there a way to do this in Excel???</p>