title: Comparing two columns in excel, inserting blank rows moving associated data
body: <p>I have a large set of data in excel that needs to be matched by column. Specifically, the data currently looks like:</p>
  
  <pre><code>Column 1 Column 2 Column 3
  1          1         aaaa
  2          3         bbbb
  3          4         cccc
  4
  </code></pre>
  
  <p>Ideally, I want the data to look like:</p>
  
  <pre><code>Column 1 Column 2 Column 3
  1         1        aaaa
  2
  3         3        bbbb
  4         4        cccc
  </code></pre>
  
  <p>I've looked at different ways of comparing Column 1 and Column 2 (similar to <a href="https://stackoverflow.com/questions/19500352/how-to-align-matching-values-in-two-columns-in-excel-and-bring-along-associated">this</a>), but haven't found a good way to a) insert the blank space where column 1 and 2 don't match and b) also attach the data in column 3. </p>
  
  <p>Any help would be greatly appreciated! Thanks!</p>