Excel 2007 Pivot Table Layouts

[ActuaryDude]

When working with a Pivot Table, repeated entries are deleted:

ABC1 DEF1 100
---- DEF2 125
ABC2 DEF1 200

(The ---- represents a blank)

This can cause problems when attempting to lookup certain values. How do you change the table so that it doesn't skip the repeates?

ABC1 DEF1 100
ABC1 DEF2 125
ABC2 DEF1 200



~ Nick ~

 

[GlennUK]

What kind of lookup are you trying to do? GetPivotData function operates quite well.