Pivot table formatting

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




--
David Ruderman
Director of Marketing
Chapman University

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

David Ruderman - Chapman University wrote:
>
> 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
>
> --
> David Ruderman
> Director of Marketing
> Chapman University

--

Dave Peterson

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.
--
David Ruderman
Director of Marketing
Chapman University


"Dave Peterson" wrote:

> 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
>
> David Ruderman - Chapman University wrote:
> >
> > 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
> >
> > --
> > David Ruderman
> > Director of Marketing
> > Chapman University
>
> --
>
> Dave Peterson
>

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

David Ruderman - Chapman University wrote:
>
> 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.
> --
> David Ruderman
> Director of Marketing
> Chapman University
>
> "Dave Peterson" wrote:
>
> > 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
> >
> > David Ruderman - Chapman University wrote:
> > >
> > > 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
> > >
> > > --
> > > David Ruderman
> > > Director of Marketing
> > > Chapman University
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson