This is what I have:

Date Stock Code
1/1/05 MSFT A
1/1/05 IBM B
1/1/05 SUNW B
1/2/05 MSFT A
1/2/05 IBM A
1/2/05 SUNW B
.....
.....
3/9/05 SUNW A

Everyday, there will be the same N stocks.


I want:

Date MSFT IBM SUNW
1/1/05 A B B
1/2/05 A A B
.....
.....
3/9/05 B A A


If my field code was a neumeric value, I would use a pivot table and
sum on Code. This would work as there would be only one symbol per
day. However, as the field Code is Text, how would I do this?


Thanks.