combining data from 2 table into a new one

i have 2 tables

table1 with columns number,category,answer
table2 wtih columns number, category, answer

table 1 looks something like this:

number category answer
1 training yes
3 coaching no

table 2 like this:

Number category answer
2 walking yes

I want to make a new table that consists out of the category answer only and should look something like this

Column heaaders should be training, coaching, walking

example,

coaching training walking
yes no yes

Can someone help me with a Query or an idea?

Thanks dave, i agree with you 100%