<Andy B shared this with us in microsoft.public.excel.misc:

Hi
First, take a copy before you start!
Select the whole area, click on Edit /Copy (or Ctrl+C) and then click
on Edit / Paste Special and select 'Transpose'

That won't work as desired!
You will have to write some VBA to achieve your goal, I guess. I have
no time now to elaborate, sorry.

--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?

How To Ask Questions The Smart Way
http://www.catb.org/~esr/faqs/smart-questions.html
How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as the
answer.
http://homepages.tesco.net/~J.deBoyn...-with-yes-or-n
o-answers.html