title: Excel PivotTable for counting words for female and male
body: <p>I have a excel like the following form:</p>
  
  <pre><code> words      male      words    female
    I           2        rose      4
    am          3        baby      6 
    sunny       4        slim      9
    baby        5        travel    11
    football    9
  </code></pre>
  
  <p>I want this excel to be a new excel like the following form with Excel PivotTable. If there are common words between male and female, the value of each other, if there is no, just show their own value, other are space. </p>
  
  <pre><code>   words       male        female
       I           2           
      am           3           
      sunny        4            
      baby         5          6
      football     9
      rose                    4
      slim                    9
      travel                  11
  </code></pre>
  
  <p>Thanks for your time and consideration!</p>