Hi. I have a correlation matrix in excel with the first row and the first column being the names of the variables.
eg
Alfa Beta Gamma
Alfa 1 0.3 0.7

Beta 0.3 1 0.5

Gamma 0.7 0.5 1

I need to transform this matrix into 3 colums, eg

Alfa Alfa 1
Alfa Beta 0.3
Alfa Gamma 0.7
.....

I have lots of matrices like this so I need to find an easy way to do it, but my excel knowledge is quite limited.
Can anyone help?