crosstab query or make new table

[tow9641609]

I have database at below
tablediagnosis
name diagnosis type
A s000 d
A k79 d
B A11 d
B 271 p
C S789 d
C V67 d
C 666 p
C 222 p

I want crosstab query or make table like at below

name diag1 diag2 diag3 diag4 op1 op2 op3 op4
A s000 k78
B A11 271
C s789 V67 666 222

please help me

ham6702723@wethai.com

 

[tow9641609]

file

I attachment file