Pivot table display field date on each line

[sebiwane]

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

 

[jdowski]

Not possible to my (limited ) 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]

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

 

[Timbo6]

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]

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]

Thx for the answer

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

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]

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]

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

 

[Timbo6]

You are welcome.

Regards

 

[tshaffer03]

WOW...what a great tip! I've struggled with this issue many times. This is such an easy solution...THANK YOU!!!!