Update Monthly Report

[accessman]

Hi Everybody:
I am new MS Access person. I encounter a problem. I got the result of the query like this:
Table 1:
Vendor Name Date 1 Paid 1 Date 2 Paid 2 Date 3 Paid 3
Micro --------1/2/05 $1
Micro ----------------------2/2/05 $2
Micro ----------------------1/2/05 $3
Micro ------------------------------------2/3/05 $4
Micro --------1/3/05 $6
DHL ----------1/2/05 $1
DHL -----------------------2/2/05 $2
DHL -----------------------1/2/05 $3
DHL --------------------------------------2/3/05 $4
DHL ----------1/3/05 $6
.....

So, how can I change like this in MS Access:
Micro 1/2/05 $1 2/2/05 $2 2/3/05 $4
Micro 1/3/05 $6 1/2/05 $3
DHL 1/2/05 $1 2/2/05 $2 2/3/05 $4
DHL 1/3/05 $6 1/2/05 $3

I want to save the space, Please let me know how to do it. Thanks a lot. Thanks.