title: Compare Two Pivot Tables
body: <p>I have two pivot tables, one in Column A, one in Column B, and they are formatted the same way.</p>
  
  <p>The pivot tables have a list of Users, and under each User a list of IDs.</p>
  
  <p>Is there a way I can compare the two pivot tables against each other? I want to match Users in both tables and see which Users have duplicate IDs.</p>
  
  <p>To help visualize, the tables look something like this:</p>
  
  <p>Table 1  </p>
  
  <pre><code>-------------------------                                          
  | DAVE  | asgh4 | lshg8 |                                         
  | MATT  | 39f8  | 2352  |                                               
  -------------------------
  </code></pre>
  
  <p>Table 2</p>
  
  <pre><code>-------------------------
  | PETER | dgghn  | lkasj|
  | DAVE  | asgh4  | 38gfj|
  -------------------------
  </code></pre>
  
  <p>I want to see matches like "DAVE" and "asgh4" because the user matches and the ID matches. Is there a way to accomplish this? Thanks!</p>