You can't do that and still keep it as a pivottable.

But you can copy the sheet (if you need to keep the pivottable) and then change
that copy to values.

Now, since the data is no longer a pivottable, you can do whatever you want.

I used a technique that Debra Dalgleish has at:
http://www.contextures.com/xlDataEntry02.html#Fill

(I use the manual method--I find it quicker than the macro!)


Dave wrote:

Hello. I would welcome someone's help on the following. I have a Pivot table
which looks like the following:

Region SalesPerson Sales
East Dave $100
Pete $200
Mike $240

I want the table to not leave the blanks on the left hand side. I want it
to look like the following:

Region SalesPerson Sales
East Dave $100
East Pete $200
East Mike $240

I am then using this data to create another table. The blanks revent me
from doing so. Does anyone know how to prevent the Pivot table from doing
this?

Thank you very much in advance.

--
DM

--

Dave Peterson