ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Pivot Table Row Formatting (https://www.excelbanter.com/excel-worksheet-functions/85904-pivot-table-row-formatting.html)

T Duquette

Pivot Table Row Formatting
 
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

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.




All times are GMT +1. The time now is 02:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com