title: Excel pivot table: How to transpose multiple value in column to a column labels
body: <p>Here's the pivot table I have in excel:
  I have a list of website with their emails address.
  Sometime you have one email per website, sometime you have 3 emails per website.
  I want to transpose the multiple emails I have for one website that are in column Email 1 into multiple field such as Email 1, Email 2, Email 3 for EACH corresponding websites.</p>
  
  <p>Here's an example of my pivot table:</p>
  
  <p><p>
  **URL      |     Email **</p>
  
  <p>site.com     | Email 1</p>
  
  <pre><code>       |Email 2
  </code></pre>
  
  <p>site2.com | Email 1</p>
  
  <p>site3.com | Email 1</p>
  
  <pre><code>       |Email 2
  
         |Email 3
  </code></pre>
  
  <p>site4.com   | Email 1</P></p>
  
  <p>I want to turn it into:</p>
  
  <p><strong>URL      |    Email   | Email 2| Email 3</strong></p>
  
  <p>site.com  | Email 1| Email 2</p>
  
  <p>site2.com | Email 1</p>
  
  <p>site3.com | Email 1| Email 2| Email 3</p>
  
  <p>site4.com   | Email 1</p>
  
  <p>Sorry about the format.
  So the idea is simple, I just need to transpose the multiple emails I have for a website into columns.
  but when I put the email field into Column Label, it takes every emails and instead of 3 emails columns labels (since I have no more than 3 emails per website) I have 7 column labels.</p>
  
  <p>Any idea of who to achieve that?</p>