query help

I have the following access table


Shop   Month    Sales
1000    1           1000
1000    2           2000
2000    1           4000
2000    2           5000

Basically there is a list of shops with sales for different months

I am trying to write a query that will list the shops and the sales
for each month across a single line
(all shops will have the same number of sales month entries)



For the sample data above I was hoping for the following



shop month1  month2
1000  1000     2000
2000  4000     5000