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.

thanks!