Hello,

Is it possible to display information in the "Data" area of a pivot table as
the actual data text instead of a numeric count, sum, average, etc?

I have data that contains a days, names, and positions. I would like to
show the day on the left as rows, the names and columns across the top, and
the position in the data portion, something like this:

Joe Sam Bob

Mon Lathe Drill Saw
Tue Drill Saw Lathe
Wed Lathe Saw Drill

Currently, I am only able to achieve something close as follows:

Joe Sam Bob

Mon Lathe 1
Drill 1
Saw 1
Tue Lathe 1
Drill 1
Saw 1

Is there any way to get the text data instead of numeric in to the data
portion of the pivot?

Thank you

Tom