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