How to transpose rows and columns in Access 2003?
- by Lisa Schwaiger
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.