Transposing columns to rows with pivot table?

Mike,

You are a star!!

Thanks so much. This saved me so much wasted time with an array that I was using between spreadsheets that would take forever to calculate.
If you are ever over on Vancouver Island, I will buy you a large frosty beverage.

Many thanks!!!!

Hello Duncan, thanks for your note, very much appreciated. I've been able to visit several Pacific islands and Los Angeles/San Francisco in the course of my work over the years, but so far not Canada. One never knows.

Regards
Mike