Newbie: Can a Pivot Table do this?

[Brian Beam]

I'm needing to create a sort of cross tabulation of data that is not
numeric.

Here's what the raw data might look like:

Date Category Attribute
5/1/03 ABC A
5/1/03 DEF Q
5/1/03 GHI R
5/1/03 ABC V
6/1/03 ABC Q
6/1/03 DEF A
6/1/03 GHI F
6/1/03 ABC V


And here's what the pivot table data would look like:

Date
Category 5/1/03 6/1/03
ABC A,V Q,V
DEF Q A
GHI R F

I understand that joining the two ABC values (A,V and Q,V) is probably not
possible, so I can join those bits of data in a separate process before
feeding it to the pivot table. But what about the other non-numeric values?

Right now, the pivot tables I've created show only a 1 (if the result field
is set to a Count, or a 0 if it's set to Sum) if there's any value in the
Attribute column of the source data.

So, once I pre-process the data to join the ABC values into a single entry,
there will never be multiple iterations of a Category within a single Date,
so I really don't need the Pivot Table to summarize any data, but just show
the actual values in the Attribute column. Is there a way to do this? I've
tried using a calculated item, but I still get a summary no matter what.

If a Pivot Table can't do this, how might I go about tabulating this data?

TIA,

Brian