Pivot table formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

There are many times where I need to take Excel data and do a pivot table,
then do another pivot table from that data (summarize the data, and then do a
pivot on the summarized data)

Is there a way to do a pivot table where each repeat value prints? For
example, if person 1 has 2 values, person 2 has 3 values, person 3 has 1
value, I would like to display:

Person Value
1 1
1 2
2 1
2 2
2 3
3 1

Right now the data displays as:

Person Value
1 1
2
2 1
2
3
3 1
 
If you convert the pivottable to values
(select the whole thing edit|copy, edit|paste special|values)
Then you can do whatever you want to the data.

(You may want to do this to a copy of the pivottable so you can still use that
pivottable.)

Then you could use some techniques at Debra Dalgleish's site to fill those empty
cells with the value above:
http://www.contextures.com/xlDataEntry02.html
 
I was never aware that one could fill as you described. That's great to
know. I'll give it a try.

So, there's no way to format pivot tables to repeat values? Any chance this
will be in the next release?

Thank you.
 
There's no way that I've seen to fill those cells and keep the pivottable.

This is the best source I've seen for new stuff in the next version:
http://blogs.msdn.com/excel/default.aspx
I was never aware that one could fill as you described. That's great to
know. I'll give it a try.

So, there's no way to format pivot tables to repeat values? Any chance this
will be in the next release?

Thank you.
Click to expand...
 
Back
Top