VFP 6.0

How do I take one column and move it to another column when I encounter what acctg_prd it sees.

for example

(there is other column not shown in this example that need to be include in the query)

acctg_prd trans_amt
0100 45.00
0200 4.00
0300 23.00

results are:
acctg_prd trans_amt 1 2 3 4
0100 45.00 45.00
0200 4.00 4.00
0300 23.00 23.00


Thanks