Pivot Table Row Formatting

[Guest]

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.

 

[Debra Dalgleish]

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 here:

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