Hi:
I am requesting help on matrix mapping.

I have a matrix that is 5000 rows x 3000 columns in R env.

Matrix:

           A          B        C       D      E

S1       0.01     0.2      -0.3     0.8    -1

S2       -2        1.4       2.3      3.1    -2

S3       -4         -3        -2        0.4    2.1



I have another excel sheet, which when I import will have two columns..


ColMap        element

A             Apple
A             Arcade
A             Almira
B             Boy
B             Balloon
B             Bat
C             Cat
.....


I want to create another matrix with elements as column names and map
 ColMap values onto elements.



new matrix:

               Apple      Arcade       Almira    Boy   Ballon ....
S1              0.01     0.01            0.01     0.2       0.2
S2              -2         -2                -2         1.4     1.4....
S3              -4         -4                -4          -3      -3  ..


I have no idea how I could do this in R.  would any one help please.

Thanks

	[[alternative HTML version deleted]]

