How can I create matrices of data in Excel?
- by sandeep
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.
