C
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!
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!