Copying Pivot Table results to another sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave Baxandall - 27 Feb 2006 18:19 GMT

After I create a pivot table I want to copy the data to another sheet. That
part is easy but how do i fill in the data that is displayed as a blank? For
example the pivot sheet result looks like
Month Item Count
jan milk 2
coffee 2
jam 2
Feb milk 3

I want my output to repeat Jan so that I can do more reporting etc
jan milk 2
jan coffee 2
jan jam 2
Feb milk 3

Signature

Thanks in advance
Dave Baxandall

Reply to this Message

John McGhie [MVP - Word and Word Macintosh] - 28 Feb 2006 11:06 GMT

Sorry Dave:

Wrong group! Most of us Word mavens are terrified of Pivot Tables.

J. E. Will be along in a minute to answer in the Excel group :-)

Cheers

On 28/2/06 5:19 AM, in article
CD961673-6D2C-4A76-8E73-56B839211FB8@microsoft.com, "Dave Baxandall"
<dlbax@telusplanet.net> wrote:

> After I create a pivot table I want to copy the data to another sheet. That
> part is easy but how do i fill in the data that is displayed as a blank? For
[quoted text clipped - 10 lines]
> jan jam 2
> Feb milk 3

Signature

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <john@mcghie.name>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 (0) 4 1209 1410

Reply to this Message

Dave Baxandall - 28 Feb 2006 14:35 GMT

Sorry, not sure what i was thinking. I will repost in the correct group.

Signature

Thanks in advance
Dave Baxandall

"John McGhie [MVP - Word and Word Macinto" wrote:

> Sorry Dave:
>
[quoted text clipped - 22 lines]
> > jan jam 2
> > Feb milk 3

Reply to this Message

JE McGimpsey - 28 Feb 2006 15:15 GMT

> On 28/2/06 5:19 AM, in article
> CD961673-6D2C-4A76-8E73-56B839211FB8@microsoft.com, "Dave Baxandall"
[quoted text clipped - 14 lines]
> > jan jam 2
> > Feb milk 3

To do this in one step would require a macro, but it's easy to fill in
manually:

Say you copied the table so that "jan" is in cell A2.

- Select from A3 to the cell in column A for the last row in your data,
with cell A3 active.
- Choose Edit/Go To/Special/Blanks
- Put

=A2

in cell A3 and type CTRL-RETURN to copy the formula.
- if you need to have the values as constants rather than formulae,
select the entire column, type CMD-C to copy, then choose Edit/Paste
Special/Values.

Reply to this Message

Mac Forum / Applications / Word / February 2006

Copying Pivot Table results to another sheet