Solved

Pivot Table in Excel

Posted on 2014-02-25
7
366 Views
Last Modified: 2014-02-25
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.
0
Comment
Question by:rosen55401
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 19

Expert Comment

by:helpfinder
Comment Utility
probably you forgot to attach an attachment?
0
 

Author Comment

by:rosen55401
Comment Utility
0
 
LVL 22

Expert Comment

by:spattewar
Comment Utility
you will not be able to do that since you are putting the email in the value field of the Pivot Table, which means that you want to perform a mathematical operation on that field. If you put the email in the Row Label field then you will see the email but will get one more level below the customer name.

What is your purpose of using the pivot table? Do you just want to show unique values?

You can do that by just by selecting columns A through D on your data page and then going to the Data tab and clicking on remove duplicates. Note that your data will change hence you can do a copy of the original data and then try this.

Let me know.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
Comment Utility
Sure you can!

1) Move email to a row field

2) On the ribbon, select PivotTableTools / Design / Layout / Report Layout / Show in tabular form

3) On the ribbon, select PivotTableTools / Design / Layout / Subtotals / Do not show subtotals
0
 
LVL 19

Expert Comment

by:helpfinder
Comment Utility
in pivot table values you can have only data liek COUNT, SUM AVG etc.
probably you have to find another way ho to handle this.
I did it for you this way:
copied column cust name from Data sheet to list sheet. I selected the range and in Data>Filter>Advanced filter I have chosen  (ticked) Unique data only. That gave me list of customers. In the next column (column C) I put VLOOKUP formula so I matched Customers with Emails
Pivot-Table-in-Question.xlsx
0
 
LVL 22

Expert Comment

by:spattewar
Comment Utility
wow..patrick I never did this. thank you for the insight. learnt something new today.
0
 

Author Closing Comment

by:rosen55401
Comment Utility
Exactly what I was looking for!  Thank you Matthewspatrick :)
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now