Sleeper: Pivot table showing text values

[jloaiza]

Hi, I have a data set like this:

ID ---Date----Evaluation
v1--01/05/03-----a1
v1--01/05/04-----a1
v1--01/05/05-----a2
v2--01/05/03-----a1
v2--01/05/04-----b1
v2--01/05/05-----b2

and want to transform it to report this:
ID--01/05/03--01/05/04--01/05/05
v1------a1----------a1----------a2
v2------a1----------b2----------b2

I tried to do it with a pivot table, but it does not have First(aggregate function), so it does not show text values.
Any help available would be pretty appreciated.

Thanks.