Thread: How do you repeat outer row field in a pivot table down the row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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
Reply With QuoteReply With Quote