View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish
 
Posts: n/a
Default Pivot Table Row Formatting

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

To create a table with a heading on each row, you could copy the pivot
table, paste it as values in another location, and fill the blanks,
using the technique shown he

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


T Duquette wrote:
Is it possible to include the first row field for all data in the table with
multiple rows? For example:
A B
June Mike 5 8
Jim 12 7
Lynn 9 14

Is it possible to have "June" show for all information in that table? I am
using the table as a reference and need to have a consistent ID to lookup.