build distance matrix

Hello and cheers to everybody since this is my first post in this forum.

My problem is how to build a distance matrix of several geographic locations.

In my Excel table I have 3 columns:

locations locations distance

A B 12
B D 25
C C 35
D A 50

I would like to generate a table (like the old notebooks used to have) where on the horizontal axis I would have A,B,C,D and the same on the vertical, something like this:

A B C D
A - 12 35 50
B - ...and so on
C
D

Is there any simple way to do this in excel?

Thank you very much in advance and have a very nice day!

Hey!
It can be done using lookup but there'll be a lot of NA errors if u dont have an exhaustive list of all the possible combinations of cities....

In matrix, cell B2=lookup(2,1/((A2=A1:A40)*(B1=B1:B40)),C1:C40)

A1:A40, B1:B40, C1:C40 are references from ur original table having From,To,Distance columns..

Hope dat helps

Regards
Mohit