Excel 2010 pivot table text values
Posted on 2015-02-04
I am trying to put some time card data into a format that makes sense to my BA. After playing around for a while, I came up with a table that sort of resembles a pivot table, except that there is only one value for each column/row intersection. I tried to put the data into a pivot table but can't get the actual value to display in the 'values' field - Excel wants to aggregate the information (I understand why it wants to do this).
How can I get it to display the actual text in the values field instead of a count or sum?
I have found a few examples online but I don't use excel very often and these solutions include steps with which I'm not familiar, and I don't know VB.
The left-hand column contains dates in the format of 2/4/2015, and the top row contains specific date/timestamps, such as 2/4/2015 10:04:44 PM. The intersection is a shift that someone worked, such as '15:00 - 20:58'. So, 15:00 - 20:58 is the shift that the employee worked on 2/4/2015, and the shift info was uploaded to the system (from the time clock) or modified on 2/4/2015 at 10:05:44 PM.