Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I have a situation where I have a list of data that I would like to "pivot", however, the data doesn't contain numbers that I would like to compare and put in the data items area. It is events that I would like to put there, so I don't want it to count, sum, multiply, etc. the data I just want it to display the text as is. Is it possible to format a Pivot Table to do this, or do I need to be using some other report? Example: DATA: Year Customer Event 2006 Joes Event 1 2006 Marys Event A 2005 Johns Event 3 I would like it to display: Joes Marys Johns 2006 Event 1 Event A 2005 Event 3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Top 5 plus Other in Pivot table | Excel Worksheet Functions | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table Problems | Excel Discussion (Misc queries) |