Make a pivot table from an existing pivot table

[CanoAko]

I'm trying to make a completely new pivot table out of an existing
pivot table where the existing table is actually the source data (not
the original data table). The problem I have is that this intermediate
pivot table has 3 columns of unique values (with over 1000 rows) before
we get to the data. I can't just copy it and make a pivot table, or
create a mirror sheet that isn't a pivot table because of the blank
cells underneath each change in value.

I have this:

Source Name Attempts Data
Mail Joe 1 654
2 700
Bob 1 300
2 400
3 800
Phone Joe 1 324
Bob 1 466

And need this to pivot:
Mail Joe 1 654
Mail Joe 2 700
Mail Bob 1 300
Mail Bob 2 400
Mail Bob 3 800
Phone Joe 1 324
Phone Bob 1 466

Do I have any options other than manually entering the repeating data
in blank cells? What do I do if I want it dynamic and have the 2nd
pivot table change when the original data is updated?

Thanks!

 

[Dave Peterson]

You can select those cells and do
Edit|Copy followed by Edit|Paste special|values.

Then you don't have a pivottable. (You may want to paste to a new worksheet to
retain the existing pivottable.)

But after you do that, you can fill those gaps by following the techniques at
Debra Dalgleish's site:
http://contextures.com/xlDataEntry02.html

I find the manual technique quicker than the program approach.

 

[CanoAko]

That was wonderful! Thanks!

You can select those cells and do
Edit|Copy followed by Edit|Paste special|values.

Then you don't have a pivottable. (You may want to paste to a new worksheet to
retain the existing pivottable.)

But after you do that, you can fill those gaps by following the techniques at
Debra Dalgleish's site:
http://contextures.com/xlDataEntry02.html

I find the manual technique quicker than the program approach.