Hi

I have the follwoing data in a spreadsheet

Emp Event Date
1 A 01.01.06
1 B 01.02.06
2 A 01.01.06
3 B 01.03.06

I would like to use a pivot table to create the following :-

Event A B
Emp
1 01.01.06 01.02.06
2 01.01.06
3 01.03.06

Instead I get :-

Count of Date Event
Emp A B Grand Total
1 1 1 2
2 1 1
3 1 1
Grand Total 2 2 4

If I go into field settings I can change the date to show sum or count etc.
but I would like to just display the date. Is this possible ? Any help
appreciated.

Thanks