Create a r-square matrix on simple strings of values

Hello,

I am trying to create a simple matrix summarising r-square correlation values with the function RSQ(), but I am failing and thought I'd ask here.

My data is organised like this:

Please Login or Register  to view this content.

And I would like to calculate any RSQ() value possible on all values for each column against each other. For instance, RSQ(columnA,columnB)=0.4 in this example.
I then would like to order the results as such:

Please Login or Register  to view this content.

I am getting lost in the INDEX and MATCH functions, and I don't really know anymore how to do this.
Many thanks in advance for your help and your time!

All the best,
G

Thanks for the answer, but I should have been clearer: my table is much bigger than a 3x3 table, and I was hoping for a more general way of doing it rather than manually. Thanks again though.

The intiial table has +600 columns, so a few hundred thousands cells expected in the matrix!
Thank you.

Hi
Try this in E7 (and copy down and across)

Formula:

Please Login or Register  to view this content.

where
$A$2:$C$5 are your date (you can modify as your needs)
$D7:$D9 and E$6:G$6 are labels
See the file