title: Align duplicates on the same rows in Excel
body: <p>two columns like these in Excel with rows duplicates and I need to make white rows on both of the columns for the cells that aren't matched:</p>
  
  <pre><code>Col1    Col2  
  A       C  
  B       I  
  C       E  
  D       D  
  E       J
  </code></pre>
  
  <p>And I need to:</p>
  
  <pre><code>A     BLANK
  
  B     BLANK
  
  C     C
  
  BLANK I
  
  D     BLANK
  
  E     E
  
  BLANK J
  </code></pre>
  
  <p>I can only expand the second row to align the first one but the unique values of the second row disappear:
        =IF(ISNA(MATCH(A1;B:B;0));"";INDEX(B:B;MATCH(A1;B:B;0)))
  Please help me </p>