You should still be able to do this even though you only have one value
column.

I have attached an example to show you what I mean


+-------------------------------------------------------------------+
|Filename: example pivot.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4659 |
+-------------------------------------------------------------------+

--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=534087