I am having issues with a pivot table in Excel. I have attached the file with the pivot table. What I am trying to do is get the Customer Name in one column and then their email address in the next column. We cannot figure out how to change the value" of email address so that we can actually see the email addresses. Any would be much appreciated.