My ignorance of pivot tables is causing me grief, I'd appreciate some help.
At least I think I should be using a pivot table.

On a worksheet I have a number of rows with 3 columns (Date, Name and
Activity). I'd like to present that data in a pivot table with Name as the
Row Heading, Date for the Column heading and Activity as the data. The
wizard will only let me put a "Count of Activity" or "Sum of Activity" in
the data field. How do I get it to just put the Activity code there, not a
count or sum or any other aggregate.

Thanks in advance for any help.