ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   pivot tables, (https://www.excelbanter.com/new-users-excel/212581-pivot-tables.html)

A

pivot tables,
 
hi guys,

i read the tutorial on pivot table on microsoft online,
and im trying to to it.

so lets say i have 3 columns (name, Date of birth, Number) and i have 3
friends, (a,b,c)

so my problem is this, when i creat the table and go to click the checkbox
for name everything is ok, BUT when I click the checkbox for DOB or Number, I
get the info inserted on the same column for Name,....its supposed to insert
it in the column next to it!!


can anyone help

Thank you l

A

Roger Govier[_3_]

pivot tables,
 
Hi

Which version of Excel are you using?

--
Regards
Roger Govier

"A" wrote in message
...
hi guys,

i read the tutorial on pivot table on microsoft online,
and im trying to to it.

so lets say i have 3 columns (name, Date of birth, Number) and i have 3
friends, (a,b,c)

so my problem is this, when i creat the table and go to click the checkbox
for name everything is ok, BUT when I click the checkbox for DOB or
Number, I
get the info inserted on the same column for Name,....its supposed to
insert
it in the column next to it!!


can anyone help

Thank you l

A



A

pivot tables,
 
Hi man

im using excel 2007



"Roger Govier" wrote:

Hi

Which version of Excel are you using?

--
Regards
Roger Govier

"A" wrote in message
...
hi guys,

i read the tutorial on pivot table on microsoft online,
and im trying to to it.

so lets say i have 3 columns (name, Date of birth, Number) and i have 3
friends, (a,b,c)

so my problem is this, when i creat the table and go to click the checkbox
for name everything is ok, BUT when I click the checkbox for DOB or
Number, I
get the info inserted on the same column for Name,....its supposed to
insert
it in the column next to it!!


can anyone help

Thank you l

A




Roger Govier[_3_]

pivot tables,
 
Hi
Click on a cell in the PT.
From the Design tabLayout sectionclick Report Layoutselect Show in
Outline Form

--
Regards
Roger Govier

"A" wrote in message
...
Hi man

im using excel 2007



"Roger Govier" wrote:

Hi

Which version of Excel are you using?

--
Regards
Roger Govier

"A" wrote in message
...
hi guys,

i read the tutorial on pivot table on microsoft online,
and im trying to to it.

so lets say i have 3 columns (name, Date of birth, Number) and i have 3
friends, (a,b,c)

so my problem is this, when i creat the table and go to click the
checkbox
for name everything is ok, BUT when I click the checkbox for DOB or
Number, I
get the info inserted on the same column for Name,....its supposed to
insert
it in the column next to it!!


can anyone help

Thank you l

A





All times are GMT +1. The time now is 12:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com