How do you repeat outer row field in a pivot table down the row
 

I want to use the pivot table information in another area, I would like the
outer row to show it's contents on every line, not as 1 line summary (nor a
merge), I'd like to see the list repeated down for the field.

How do you repeat outer row field in a pivot table down the row
 

You can't do this and keep the pivottable.

But you could copy and paste special values (on another sheet???) and then fill
the empty cells with one of the techniques from Debra Dalgleish's site:

http://contextures.com/xlDataEntry02.html

WINDMILL wrote:

I want to use the pivot table information in another area, I would like the
outer row to show it's contents on every line, not as 1 line summary (nor a
merge), I'd like to see the list repeated down for the field.

--

Dave Peterson