Generally, in a properly normalized database, you don't!
You can use a "Crosstab Query" to spread record values across the page in
columns; or a "Normalizing Union Query" to take a wide-flat table and turn it
into a tall-thin one; or a "Pivot Table Query" using Excel to analyze data.
Could you describe what data you're working with and what you want to
accomplish with it?
