View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jenn jenn is offline
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