Copying Pivot Table results to another sheet

[Dave Baxandall]

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

 

[John McGhie [MVP - Word and Word Macintosh]]

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

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

--

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

John McGhie <[email protected]>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 (0) 4 1209 1410

 

[Dave Baxandall]

Sorry, not sure what i was thinking. I will repost in the correct group.
--
Thanks in advance
Dave Baxandall

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

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

--

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

John McGhie <[email protected]>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 (0) 4 1209 1410

 

[JE McGimpsey]

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

[/QUOTE]

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.