Pivot Tables & Multiple Row Entries

P

POD

Hi,

When there are 1 or more descriptive fields in a pivot table and
the entries in field 2 or further on are repeated, the values in the
previous field are left blank for each repition of the subsequent
field.
This causes problems for further sorting etc...unless you use
formulas.

Does anybody know how to ensure that all cells in the descriptive
fields
(rows in the layout section) are populated with the appropriate value?

Thanks

POD
 
B

Bernie Deitrick

POD,

You can't do that, and have a pivot table. But you can copy the PT, convert it to values, and then
fill in the blanks by selecting Edit Go To.. Special Blanks (done immediately after the paste, with
the whole table of values selected), then pressing the up arrow once, and pressing Ctrl-Enter. Then
copy the whole table and paste values again.

HTH,
Bernie
MS Excel MVP
 
Top