jloaiza
09-27-2005, 05:59 AM
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.
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.