[mso] Re: Pivot table format problems
- From: Alison <alison325@xxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Sun, 29 Sep 2002 23:02:12 -0700 (PDT)
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).
//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:
