Excel formula to combine

[shan]

Hello Everyone,

Need your assistance for below..

I have below data. The data is huge.

I need a excel formula which will give me output in "Route" column as per the logic mentioned in G and H column in attached file.

[shan]

If no excel formula can be set ... then can anybody assist me with a macro code...