Pivot Table selection that will allow Grouped fields to show up ineach cell

  • Thread starter Thread starter Dave K
  • Start date Start date
D

Dave K

Hello - Is there a Pivot Table selection that will allow Grouped
fields to show up in each cell? The standard view generates a blank in
each new row...but I need to be able to display the grouped data in
each cell, rather than a blank if possible.

For example:

Month State Amount
Jan TN 500
Blank KY 300
Blank GA 25
Feb TN 35
Blank KY 28

I am hoping there is a pivot table option that will allow me to
display "Jan" instead of blanks in the above example
 
Not through xl2007. I don't know about xl2010.

But you could copy the pivottable to a new sheet, convert it to values and fill
those empty cells with the value from the cell above.

If you want to try, Debra Dalgleish shares a few techniques here:
http://contextures.com/xlDataEntry02.html
 
Back
Top