Hi S Davis,
I tried it . It works but numbers briefly flash and then cells go blank!

Bob

"S Davis" wrote:

You can copy and paste special transpose. That should work.
Alternatively there is a TRANSPOSE command built in to excel.