Pivot table display field date on each line

sebiwane

New Member
Joined
Nov 16, 2005
Messages
11
Hi,

I'm making a Pivot table and i'd like that the different field will be displayed on each line...

here is an exampe of what i have and what i want to have

______Group____Average age
Man_____1_________16
_________2_________22
_________3_________25
_________4_________33
_________5_________48
Woman__1_________16
_________2_________22
_________3_________25
_________4_________33
_________5_________48


Result needed


______Group____Average age
Man_____1_________16
Man_____2_________22
Man_____3_________25
Man_____4_________33
Man_____5_________48
Woman__1_________16
Woman__2_________22
Woman__3_________25
Woman__4_________33
Woman__5_________48



Where can i found the option to edit? if it's possible...


thanx,

Sebastien
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

jdowski

Board Regular
Joined
Apr 21, 2002
Messages
235
Not possible to my (limited :confused: ) knowledge......
Don't know if you'd consider it an acceptable solution but you can copy the pivot table and paste special values & formats to convert it to straight data and then fill in the missing cells......I wonder if this will be addressed in Excel 12 ????
 

sebiwane

New Member
Joined
Nov 16, 2005
Messages
11
thx for the reply but no, the copy past isnt an option in my case... i used a simple example but the real PT is about 10.000 lines :p
 

Timbo6

New Member
Joined
Nov 15, 2005
Messages
7
Try paste special to another sheet with the title in A1.

Select Column A
goto edit special blanks
formula bar =a2
ctrl&enter

OK ?
 

jdowski

Board Regular
Joined
Apr 21, 2002
Messages
235

ADVERTISEMENT

I'm afraid you may be out of luck then.

There is an option to print label headings at the top of each printed page within a pivot table so that users of a printed copy of your pivot table will see a label for each row field at least once on each page but beyond that what you're asking isn't possible within a pivot table in the present incarnation(s) of Excel. :x
 

sebiwane

New Member
Joined
Nov 16, 2005
Messages
11
Thx for the answer

well that was i thinking... and in one way, i'm happy of that answer :p

Ussually i can find the anwser of my problem myself... but it there is no answer, it's normal i cant find it :D

seb
 

Timbo6

New Member
Joined
Nov 15, 2005
Messages
7

ADVERTISEMENT

Did u try what i suggested ?

Try :-

paste special value the pivot to another sheet
with the title line, headers of each column, in A1.
Select Column A
edit goto special blanks, OK
click in the formula bar, with the mouse
=a2
ctrl&enter

The gaps should be filled

OK ?
 

mikeruurds

New Member
Joined
Dec 15, 2005
Messages
6
Hey Timbo6!

Thanks for that suggestion... I've been wrestling witrh the same problem as the OP and your solution worked like a dream!!!!!

You've saved me at least 4 hours of dragging my mouse around :)

Kind regards

Michael
 

tshaffer03

New Member
Joined
Jul 7, 2003
Messages
12
WOW...what a great tip! I've struggled with this issue many times. This is such an easy solution...THANK YOU!!!!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,167
Messages
5,570,640
Members
412,334
Latest member
ExcelForLifeDontHate
Top