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?