Appending Question

[maxxximaniac]

Hey Everyone,

I am trying to make a pivottable but need to organize my data fist.

I need to somehow append the Operator Name to a field on the same record of Jobs processed
Example

Please see the database under "qry_Trim"

Current:
$BOGLE
(sca)
(cca)
(cc2)
(bal)
(act)


Want:

$BOGLE | (sca)
$BOGLE | (cca)
$BOGLE | (cc2)
$BOGLE | (bal)
$BOGLE | (act)


Is there any way this can be acheived with a query?

Any help is appreciated.
Thanks!