title: Remove Duplicate Cells in a Row
body: <p>Just to clarify :
  I don't want to remove duplicates rows, I want to remove Duplicate Cells within a row</p>
  
  <p>So here's a classic address table, and in some row there's duplicate entries
  I need to remove those entries.
  Most of what I've seen in VBA is used to remove duplicates values within a column, but I can't find a way to remove duplicate values within a row.</p>
  
  <pre><code>Name  |        Address1 |       Address2 |    City |    Country
  
  Peter | 2 foobar street |2 foobar street |  Boston |    USA
  </code></pre>
  
  <p>And I want it to be like :</p>
  
  <pre><code>Name  |         Address1 |  Address2 |   City  |    Country
  
  Peter | 2 foobar street  |           |  Boston |    USA
  </code></pre>
  
  <p>I've write a macro that will loop through all the rows and then every columns for each rows, but I have no clue as to how to spot duplicate within teh different cells within teh same row.</p>
  
  <p>here's the code below:</p>
  
  <pre><code>Sub Removedupe()   
     Dim LastRow As Long
     Dim LastColumn As Long
     Dim NextCol As Long
  
     LastRow = Cells.Find(What:="*", After:=Range("A1"), SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row    
     LastColumn = Cells.Find(What:="*", After:=Range("A1"), SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column
  
     For counterRow = 1 To LastRow               
         'I'm stuck here: how to remove a duplicate values within that row?         
     Next counterRow   
  End Sub
  </code></pre>