Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution
My approach was to first create 2 fields - (a) Source and (b) Destination. In order to do this, I used a multi-row tool to input the trip order 2 right next to trip order 1 and so on and so forth. Then it was easy using the distance tool to calculate the distance