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

Pivot table formatting
 

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

Pivot table formatting
 

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

Pivot table formatting
 

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