Convert table to list

[kvn]

Hi I am having difficulty converting a table to a list. However the table is a database of distances between cities and the list I want to create needs to omit repetitive data (ex since City 1 to City 2 will be listed first City 2 to to City 1 can be omitted). I also want to omit City 1 to City 1 data as it is redundant. I have attached a spreadsheet demonstrating my data and what I am looking for. Is this possible? Any help with be greatly appreciated.

Kevin

[protonLeah]

Range	Name
B2:F6	DistanceMatrix
B1:F1	Destination
A2:A6	Origin

C13:

Please Login or Register  to view this content.

and copied down

[kvn]

Thanks Ben

This works great. However is there a way to automatically omit the 'city to city' scenarios which have already been included to create the list (ie if City 1 to City 2 is listed than I don't want to list City 2 to City 1)? Your solution is dependent on this part of the list being created already. The reason I ask this is because the table i am using is 140 x 140 and automating this step would be a huge help. Thanks for your help.

Regards,
Kevin

[protonLeah]

Here's a macro version:

Please Login or Register  to view this content.