How do I transpose rows and columns in Access 2003? I have a multiple tables that I need to do this on.

(I've reworded my question because feedback tells me it was confusing how I originally stated it.)

Each table has 30 fields and 20 records.
Lets say my fields are Name, Weight, Zip Code, Quality4, Quality5, Quality6 through Quality30 which is favorite movie. Let's say the records each describe a person. The people are Alice, Betty, Chuck, Dave, Edward etc through Tommy..

I can easily make a report like this:

  >>Alice...120....35055---etc, etc, etc...Jaws  
  Betty....125....35212...etc, etc, etc...StarWars  
  etc  
  etc  
  etc  
  Tommy...200...35213...etc, etc, etc...Adaptation

But what I would like to do is transpose those rows and columns so my report displays like this

  >>Alice........Betty......etc,etc,etc...Tommy  
  120.........125........etc, etc, etc...200  
  35055.....35212....etc, etc, etc...35213  
  etc   
  etc  
  etc  
  Jaws...StarWars..etc,etc,etc...Adaptation

Thanks for any help.