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...