Hi ,
I did as you said, I dragged the value field in to the Data Area , it
automatically does a count - I tried Sum, but it just says 1 ..

"Peo Sjoblom" wrote:

Drag the NAME field to the row and the DATE field to the column, right
click report and select table options, then deselect both Grand totals
options

--
Regards,

Peo Sjoblom


"JK" wrote in message
...
Hi ,
I have data that looks like

NAME DATE VALUE
a Jan 10
a feb 12
b jan 13
b Feb 14
c Jan 15
c Feb 16
-------------------------------
and I want the data displayed as
-------------------------------------
Jan Feb
a 10 12
b 13 14
c 15 16

---------
How can I do this in Excel ? Any help is appreciated. Thanks