Grouping columns based on row value

Puru

Hi

Looking to connect row 2 Field 1 value based on Field 2 row 1 value and follow same logic for all rows.

So that Field 2 row value is always next row Field 1 value.

Thanks

Field 1	Field 2
Paris	Milan
London	Rome
Milan	Zurich
Barcelona	London
Zurich	Barcelona
London	Amsterdam
Amsterdam	Rome

Puru

Thanks again

I have modified City names and London was repeating causing confusion.

Attaching the new Macro based on one you sent, however the final sequence is not the desired one though the leg shows correct association.

Original				Desired one
ID	Field 1	Field 2		ID	Field 1	Field 2
1	Paris	Milan		1	Paris	Milan
2	Amsterdam	Rome		3	Milan	Zurich
3	Milan	Zurich		5	Zurich	Barcelona
4	Barcelona	Amsterdam		4	Barcelona	Amsterdam
5	Zurich	Barcelona		2	Amsterdam	Rome
6	Rome	Frankfurt		6	Rome	Frankfurt

CityMatch.yxmc