Look into crosstab queries - they do what you're asking.
For example, given a query consisting of month, sales associate, and monthly sales, you can use a crosstab to have months across the top, sales associates down, and their monthly sales as the data.