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

[DavidP]

Do you mean like this?

[Puru]

Hey

I am looking for result like as follows. Multi row works but it picks up only single cell value. 

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

[ydmuley]

@Puru You can leverage Iterative Macro to solve your problem

I have attached the workflow here.

Kindly note that the duplicate values might not give you the exact output. Hope this helps or at least gives you an idea.

[Puru]

Thanks a lot.

Not sure if there is any error opening Macro but it shows following:

[ydmuley]

My bad! re-attaching - Please check

[Puru]

Thanks again

This did not open either. Would you want to open the workflow, paste screen shot with notations?

Also should the Macro file be not yxmc?

[ydmuley]

Here we go!

[Puru · Accepted solution]

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