Cross table

[yacine_b]

Hi,

I have the following table:

X	Y	Z
x3	y2	z3
x1	y2	z4
x1	y2	z1
x4	y1	z1
x2	y4	z3
x3	y4	z2
x2	y3	z2
x3	y2	z1
x3	y4	z1
x1	y3	z1

I need to get the following table knowing that :

- the cell (x,1)=3 contain how many "x1" in the column "X" (in the first table)

- the cell (y,2)=4 contain how many "y2" in the column "Y" (in the first table)

- and so on

	1	2	3	4
x	3	2	4	1
y	1	4	2	3
z	5	2	2	1

Regards,

Yacine