Pivot Table - without aggregating/Summarizing
 

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

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

Pivot Table - without aggregating/Summarizing
 

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

Pivot Table - without aggregating/Summarizing
 

Your values may be text, instead of numbers. There are instructions here
for changing them to real numbers:

http://www.contextures.com/xlDataEntry03.html

Then, refresh the pivot table, and the sum should work correctly.

JK wrote:
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





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot Table - without aggregating/Summarizing
 

Thanks - it works !!

"Debra Dalgleish" wrote:

Your values may be text, instead of numbers. There are instructions here
for changing them to real numbers:

http://www.contextures.com/xlDataEntry03.html

Then, refresh the pivot table, and the sum should work correctly.

JK wrote:
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





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html