Can I return text in a pivot table

[adsxvii]

Quick example I have 3 columns. A is Home Team. B is Away Team. C is game number for home team. What I want the pivot table to look like is: the rows would show the home team, the columns would show the game number and the crossing of these 2 would show the away team but I can't seem to return a text value. Any ideas?

 

[RoryA]

You can't do that with a pivot table I'm afraid. You would have to use formulas.

 

[adsxvii]

Thanks was just trying to speed up some spreadsheets

 

[Fazza]

Maybe you could use a query table (not pivot table) with a cross tab result. Use the MAX function. SQL something like (from memory, unchecked)

TRANSFORM MAX(away)
SELECT home
FROM source
GROUP BY home
PIVOT `game number`

I'll have a search for some old examples.

 

[Fazza]

Some old examples, HTH. F

http://www.mrexcel.com/forum/showthread.php?t=263782
http://www.mrexcel.com/forum/showthread.php?t=332486