LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 107
Default pivot table format

Hi,

I want to fill the pivot table columns with the value for that column. Is
there any way to do this except manually filling each empty row?
My pivot table looks like:

22 young cut mixed 2003 Fall
2004 Spring
Fall
23 young cut conifer 2003 Fall
2004 Spring
Fall
25 young cut mixed 2003 Fall
2004 Spring
Fall
and I want it to look like:

22 young cut mixed 2003
22 young cut mixed 2004
22 young cut mixed 2004
23 young cut conifer 2003
23 young cut conifer 2004
23 young cut conifer 2004
25 young cut mixed 2003
25 young cut mixed 2004
25 young cut mixed 2004



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
format pivot table confused Excel Worksheet Functions 0 July 18th 06 11:03 AM
Pivot Table Format cer9 Excel Discussion (Misc queries) 1 May 30th 06 10:05 PM
Help on Pivot Table Format Alan Tang Excel Worksheet Functions 1 February 8th 06 05:59 PM
how to format in pivot table H Nguyen Excel Discussion (Misc queries) 2 July 13th 05 10:36 PM
Format a Pivot Table Jaye Excel Discussion (Misc queries) 3 January 7th 05 01:11 AM


All times are GMT +1. The time now is 09:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"