You are limited to 256 columns in XL2003 (minus, of course, the
columns you are already using), so you can only do this if you have
fewer rows than this number:

Highlight all your data (including headings) and click <copy>, then
move the cursor to the right so that it is not in the current data
area and click Edit | Paste Special | Transpose (check) | OK then
<Esc>.

Your data should now be arranged as you want it, and you can delete
the original columns.

Hope this helps.

Pete