Pivot with Text? Is this scenario possible?

[Dolemitefunk]

Hello I have a data set and want to create a pivot(?) with text as values It is easier if I show you an example:

Name Class
Dave Science
Dave Math
Dave English
Susan Math
Susan English
Mary Art
Jason Art
Jason Math

And I want my result to be as follows:

Dave: Science Math English
Susan: Math English
Mary: Art
Jason: Art Math


Is this possible? Any help would be greatly appreciated.

 

[Andrew Poulsom]

You must have a Data field in a pivot table. You can do this:

Excel 2003
	D	E	F	G	H
1	Count of Class	Class
2	Name	Art	English	Math	Science
3	Dave		1	1	1
4	Jason	1		1
5	Mary	1
6	Susan		1	1
Sheet3

 

[Dolemitefunk]

Hello Thank you for the response, the problem I have with this method is that I have 5000 names and about 500 classes. The reason I want to make a table in the fashion I showed is to use that table in a lookup to add to a bigger table.

 

[Fazza]

hi,

Text can be returned in a cross-tab report. I've posted several times in the past but i can't search for old posts right now.

regards

 

[Fazza]

an old thread (there will be others)

http://www.mrexcel.com/forum/excel-questions/396182-pivot-table-text-values.html