Excel Pivot Table - How can I return a date in the row value?

0

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?

Twila

Posted 2016-04-04T15:52:01.783

Reputation: 1

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 – 2016-04-04T16:02:31.733

Please note that [SU] 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 – 2016-04-04T16:02:47.597

Answers

1

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.

Deborah

Posted 2016-04-04T15:52:01.783

Reputation: 13

Asked: 2016-04-04T15:52:01.783

Viewed: 11 228 times

Active: 2018-08-05T05:00:00.467