![]() |
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. |
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