Iterative Macro to sort Route

I have a dataset with start and end locations in 2 seperate columns. The data is shuffled. The end location is the new start location in another row. How can I sort this to get an output like this

Before

Barcelona -> Paris

Madrid ->New York

Paris -> Madrid

After:

Barcelona -> Paris

Paris -> Madrid

Madrid ->New York

...

Macros

Accepted answers

LordNeilLord

Hey @outwork

How about this?

I added some functionality to find the first journey (based on the first unique start location) but you can ditch that if you don't need it.

I've also set the number of iterations to 10 which you can change depending on how many legs you might need.

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

AirportLeg.yxzp

All comments

LordNeilLord

Hey @outwork

How about this?

I added some functionality to find the first journey (based on the first unique start location) but you can ditch that if you don't need it.

I've also set the number of iterations to 10 which you can change depending on how many legs you might need.

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

AirportLeg.yxzp

outwork

exactly what I was looking for. Thanks a lot LordNeilLord! Higly appreciated. Can you recommend further sources to learn macros and worklows beside simply building them?

annaprosvetova

Thank you for posting this solution, Neil! Was trying to solve a similar problem, and your workflow is just perfect!

handa997

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703