SQL Queries

I need to find out how to take a table in this format:

Column1 Column2 Column3 Column4 Column5

AA BB 1 2 3
AA BB 4 5 6
AA BB 7 8 9

And put the information into this format:

AA BB 1 2 3 4 5 6 7 8 9

I need to combine all records that have the same first two fields. In this example is turning three records into one. But this should be outputted to a Microsoft Excel spreedsheet and i am working in Access 97.
Any ideas would be very helpful because i have completely drawn a blank.

Thanks
Justin