title: Can Excel sort on correspondence to another column?
body: <p>What I have: two columns of text data, that are given to contain only distinct (no duplicate) items.</p>
  
  <p>What I want: The second column sorted such that corresponding items are aligned in the same rows.  If the first column contains an item with no match in the second column, that row is left blank in the second column.  If the second column contains items with no match in the first, all such items are appended below the last row of the first column.  While not required, feel free to assume the first column is sorted alphabetically.</p>
  
  
  <pre>
  Example   
  Before         After 
  Col1    Col2    Col1 Col2
  A       Q       A       A
  B       E       B       B
  C       B       C       
  D       W       D       
  E       A       E       E
                          Q
                          W
  </pre>
  </p>
  
  <p>This small example is quite easy to do by eyeball, but my data may contain from a few hundred to about two thousand items.</p>
  
  <p>Thanks in advance.</p>