Reorder rows based on condition

[Hakimipous]

Hello,

I would like to know how is it possible to reorders rows from a large dataset based on certain condition.

For example from a Dataset looking like :

Step 1	Step 2
Bruxelles	Anvers
Mons	Liege
Anvers	Mons
Liege	Gand

To : 

Step 1	Step 2
Bruxelles	Anvers
Anvers	Mons
Mons	Liege
Liege	Gand

Basically, the condition is that there has to be a continuity between the rows. A city in  step 1 has to be the same city as the previous row in Step 2

I'm looking for a way to make it work in a much larger dataset, as this is just an example of what I'm trying to achieve.

Thanks for reading!

[MarqueeCrew · Accepted solution]

This calls for an iterative macro. It coincidentally is a problem that is covered in the advanced certification test. If you take training on iteration you should be able to solve this challenge.

Cheers,

Mark

[Hakimipous]

Thanks for the tip, I wasn't quite sure what way to look for to solve this