I have raw data that includes hundreds of employees who have completed many different training courses and I am needing to insert a pivot table that shows the course name as the column labels, the employee name as the row/filter and rather than return a sum or count of value, I need it to show the date that employee completed the course (which is in the raw data) Is there a way to do this in Excel 2010 using pivot tables? Does anyone have a better suggestion?

  • 2
    Please edit your question to include some example (mock) data (before and after). See Format Text as a Table for a web utility that will help you to create a nice data table you can paste into your question. – DavidPostill Apr 4 '16 at 16:02
  • Please note that Super User is not a script writing service. If you tell us what you have tried so far (including any scripts you are using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?. – DavidPostill Apr 4 '16 at 16:02

Pivot example

Is this what you are maybe looking for. If it is, the assumption here is that one individual only went on a specific course once. Therefore under value field settings you can pick either sum or max or min and then format the numbers of the pivot table as dates.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.