[mso] Re: Pivot table format problems

Hi Bryan

This sort of thing has come up before on one of the
lists I'm on (not sure whether this or another one)
and I kept a copy of the answer (not sure who to give
the credit to though).  I've certainly found it very
handy.

First, you will need to "copy and paste values" with
your pivot table.  You can paste values straight over
the top of the existing pivot, or somewhere else.

Then, follow this procedure:  (this is what I kept
from the other time it was discussed on a list):

QUESTION
==========

What I need is a way to "Fill each cell in the column
I select with the contents of the cell above if the
current cell is empty".

i.e. I have

AAA     one     two
        three   four
BBB     six     seven
        eight   nine
        ten     eleven

and want to be able to select a column either by
clicking on it or having it written in the macro/code
(in this case A) and then end up with

AAA     one     two
AAA     three   four
BBB     six     seven
BBB     eight   nine
BBB     ten     eleven


ANSWER
=========

Let's say the column you want to fill is column A. 
The way I always do this sort of thing is to use a
blank column (say column D), copy the value in cell A1
and enter the following formula in the next cell
below:

=IF(A2="",D1,A2)

Copy this formula down, copy column D, paste it back
onto itself as values and then copy and paste it to
column A.

Alternatively, you can put the formula =A1 in cell A2
(or any suitable blank cell), copy it, select the
range you want to fill, and then select Edit, Go To,
click Special and select Blanks.  This will highlight
blank cells in the column.  Paste your formula and
then
copy the column and paste it back onto itself as
values.  This doesn't seem to fill blanks after the
last value, however.

--- Bryan deSilva <improvisations@xxxxxxxxxxxxxx>
wrote:
How do I make the first column display on every row.  
Right now it summarizes and only displays on the break
/ the first time it would logically show up. I need it
on every row.

If I can't do this, I'd like to copy / paste the pivot
to a new sheet and run a macro to fill out this column.

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: