Build report in Access

I have a query that lists the weekly totals for 3 offices. It is grouped by the week number Week: Format([Bookings.DateRecorded],"ww".

The resulting query looks something like this:

Week           Office            Office Weekly Total
5                  Office A               500
5                  Office B                750
5                  Office C                 600
6                  Office A               100
6                  Office B                300
6                  Office C                 400

The end result I would like to be a report with Week number in Column 1. Office A week total is Column 2. Office B week total in Column 3.

Something like this:

Week           Office A Week Total               Office B Week Total              Office C Week Total
5                             500                                                  750                                         600
6                              100                                                 300                                          400

Now that I write this, I think I have to change the query, not the report. The query is a 3 column query. Week, Office (which is grouped) then Total (which is sum). How do I add more columns to the query to it only adds Office A, then column for Office B.

Hope I am making sense. THanks!