If you want to keep it a pivottable, then you're going to have to live with it.
But if you convert it to values (it won't be a pivottable anymore), you can fill
those empty cells using the techniques at Debra Dalgleish's site:
http://www.contextures.com/xlDataEntry02.html
You may want to copy that worksheet, then convert the copy to values (if you'll
still need the pivottable).
danielz wrote:
Hi all !
Apologies if this is the wrong place to post this question (or if it is
a stupid question - more likely!) as this is my first post.
I would like to do a pivot table on some data I have - the only problem
is that the data is not completely filled in, ie:
Contact 1 Product 1
Product 2
Product 3
Contact 2 Product 1
..
instead of :
Contact 1 Product 1
Contact 1 Product 2
Contact 1 Product 3
Contact 2 Product 1
Is there any way to get Excel to deal with this elegantly ?
Thank you !
Daniel
--
danielz
------------------------------------------------------------------------
danielz's Profile: http://www.excelforum.com/member.php...o&userid=33151
View this thread: http://www.excelforum.com/showthread...hreadid=529641
--
Dave Peterson