I want to create a 4*4 matrix in excel 2007 by taking three or more columns or conditions for example

Column index    Row index   Name
1              2             x
2              3             y
3              4             z
4              1             p

this is how data looks and i want it for 1*1 cell as p and 1*2 cell as x and so on. and I want out put as follows

matrix  1   2   3   4
1       p   x   y   z
2       p   x   y   z
3       p   x   y   z
4       p   x   y   z

and I have very huge data like this some times the matrix size goes up to 60*60 also.