Return value pairs based on first row and column

Question

Gnumeric has a nice tool for calculating correlations, but is limited in terms of specifying your output. It looks like this, Figure 8-7 :

Correlations | pressure | distance | height
pressure     |        1 |          |
distance     | 0.9841073|        1 |
height       | 0.7633996| 0.7239509|      1

I would like to generate pairs like this:

pressure pressure  1
pressure distance  -
pressure height    -
distance pressure  0.9841073
distance distance  1
distance height    -
height pressure    0.7633996
height distance    0.7239509
height height      1

I'm fine with 1's and blanks, but it would be nice if I could avoid them. It doesn't have to be within a spreadsheet.

Answer 1

This is a pretty straightforward Index/Match:

=INDEX($B$2:$D$4,MATCH($A6,$A$2:$A$4,0),MATCH($B6,$B$1:$D$1,0))

Assuming your data is like the below: