ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Display Text in the Data Area of a Pivot Table (https://www.excelbanter.com/excel-discussion-misc-queries/38816-display-text-data-area-pivot-table.html)

Wayne Wilmeth

Display Text in the Data Area of a Pivot Table
 
I would like to simply display text in the data area of a pivot table without
summarizing it. For example, take the following database:

Date Time Instructor
8/9 8am Jones
8/9 9am Smith
8/10 8am Anderson
8/10 9am Doe
....etc

and display it in a pivot table like so:

| 8/9 | 8/10
---------------------------------
8am | Jones | Anderson
9am | Smith | Doe

thanks.



All times are GMT +1. The time now is 09:03 AM.

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