Skip to Content
0
Former Member
Feb 22, 2011 at 09:02 AM

Crosstab

36 Views

hi, all

i want to create a crosstab like below:

A B C D

A 1,000 null null null

B null 99.5 null null

C null null 99.85 null

D null null null 100

but actually i got the below:

A B C D

A 1,000 1,000 1,000 1,000

B 99.5 99.5 99.5 99.5

C 99.85 99.85 99.85 99.85

D 100 100 100 100

anyone can help me?thanks.

Edited by: Ada_Wei on Feb 22, 2011 10:03 AM