Hopefully a basic query question

Good afternoon,

I am trying to create a query. Underlying data in table is:

Job No/Cost Type/$

J8000/1/3000
J8000/2/2000
J8000/2/5000
J8000/2/1000

In the above a Cost type of 1 equates to Labour cost, and a Cost type of 2
equates to Materials cost.

I want the resulting query to be as follows:

Job No/Labour$/Material$
J8000/3000/8000

However for the life of me I cannot figure out how to achieve this in Query
(assuming that I actually can...)

Is this possible, can someone help (after 5 hours of trying I am clueless)

Thanks

James
.