Thanks - careful though, Pivot tables are addictive!
Paul

On Feb 1, 1:58*am, GS wrote:
Hi Paul,

Just want to say thanks for the clear, concise instruction. I too have
never used Pivot Table and so I decided to try your suggestion using
the OP's data. I was in xl10 and so the wizard is slightly different
but you instructions were clear enough to follow and so was no problem.

Works beautifully!

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc