Thread: Pivot Table
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Pivot Table

The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat.

To create the table with a heading on each row, you can copy the table,
and fill the blanks:

http://www.contextures.com/xlDataEntry02.html

Tom wrote:
How do you get ingformation to populate all cells in Piviot table.
If a collum 1 is duplicated it only populates 1 time & is blank on next line.



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com