title: How to transpose rows and columns in Access 2003?
body: <p>How do I transpose rows and columns in Access 2003?  I have a multiple tables that I need to do this on.  </p>
  
  <p>(I've reworded my question because feedback tells me it was confusing how I originally stated it.)</p>
  
  <p>Each table has 30 fields and 20 records.<br>
  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..</p>
  
  <p>I can easily make a report like this:</p>
  
  <pre><code>  &gt;&gt;Alice...120....35055---etc, etc, etc...Jaws  
    Betty....125....35212...etc, etc, etc...StarWars  
    etc  
    etc  
    etc  
    Tommy...200...35213...etc, etc, etc...Adaptation  
  </code></pre>
  
  <p>But what I would like to do is transpose those rows and columns so my report displays like this  </p>
  
  <pre><code>  &gt;&gt;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
  </code></pre>
  
  <p>Thanks for any help.</p>