"Annette" wrote in message
...
How can I transpose the above other than selecting each record
individually and paste special with transpose. I have thousands of
records and would like to just run a macro to do the job.

I have a 2-page code macro for transposing a range with
all possible options.
I can send you a text file by e-mail.

Ciao
Bruno