Hi,

I’m trying to build a matrix of data and am not sure how to approach this.

I have a table of people with addresses. Then I have a second table of buildings with addresses. I want to make a 3rd table – the matrix – of the distance between eeach person and each building.

I though I could make a table of lists, but it does not appear possible to apply math formulas to a list of values.

Maybe there’s a clever way to use column names to reference rows in another table?

Maybe some other approach?