LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Wayne Wilmeth
 
Posts: n/a
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Sort & Top List excel_user123456 Excel Discussion (Misc queries) 0 June 23rd 05 08:53 PM
Pivot Table for survey data w/ questions as Rows & poss answrs as pfwebadmin Excel Discussion (Misc queries) 0 May 17th 05 02:31 PM
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 07:24 PM
Pivot Table Data Spencer Hutton Excel Worksheet Functions 2 March 2nd 05 06:45 PM
Pivot Table Auto Update Data Source? Ket Excel Worksheet Functions 1 February 18th 05 11:14 PM


All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"