Pivot Table

I have a CSV file with over 500 records. I want to pivot the data by tech and date resolved. The only problem is my date field has time also. Is there a way to pivot this so I can have the tech names which would be going down 1 column and the date going across 1 row and then I'd have the count of incidents for each tech by date? Unless someone else has a better way to sort this?  I need it to look something like this ...

         9/10/12  9/11/12  9/12/12  9/13/12  9/14/12
John      1            1            3             4              5

Joe        1            1            3             4              5

Jane      1            1            3             4              5
LVL 19
Edward PamiasTeam Lead RRS DeskAsked:
Who is Participating?
 
SteveCommented:
you can set it up as you wish, then right click on the date portion of the pivot table.
Select Group then you can select days only. This will group by days, and should then count correctly.
0
 
Edward PamiasTeam Lead RRS DeskAuthor Commented:
I've requested that this question be deleted for the following reason:

I fixed it myself.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.