Convert a matrix into a dataframe

Question

This a generic question, let' say I have:

matrix=replicate(5, rnorm(10))

I want a data.frame with 3 columns: row number, column number, matrix value.

Answer 1

What you are looking for is melt inside library(reshape)

melt(matrix)

edit: use reshape2 instead.