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

Presuming you are referring to a pasted values only copy of a pivot table ..

Try Debra's page at:
http://www.contextures.com/xlDataEntry02.html
Excel -- Data Entry -- Fill Blank Cells

Fill Blank Cells
Fill Blank Cells Programmatically*

*There's a Sub FillColBlanks() by Dave Peterson
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"jenn" wrote:
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