View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Pivot Table - without aggregating/Summarizing

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