Given Out put desired (Using Formula)
ADDKRT
KRTADD
Round Trip ADDKRTADD
ADDJNB
JNBDAR
DARADD
Round Trip ADDJNBDARADD
ADDHKG
HKGMAAADD
Round Trip ADDHKGMAAADD
-
HKGMAAADD
Round Trip HKGMAAADD
ADDCAIBRU
BRUDXBHKG
HKGMAAADD
Round Trip ADDCAIBRUDXBHKGMAAADD
ADDCAILGG
LGGLUXPNR
PNRADD
Round Trip ADDCAILGGLUXPNRADD
ADDCAILGG
LGGBRUDXB
DXBHKG
HKGMAAADD
Round Trip ADDCAILGGBRUDXBHKGMAAADD
ADDLGG
LGGLOS
LOSLGG
LGGACCLOSLGG
LGGADD
Round Trip ADDLGGLOSLGGACCLOSLGGADD
Description of what i have {left side above} and what i am trying to do {right side above}
left side above are place (sectors e.g the first one is Addis Ababa-Khartoum & Khartoum-Addis Ababa) and immediately followed by "Round Trip". and what i need to get is, as shown on the right side above to concatenate the cells between the two consecutive "Round Trips" starting from above and leaving the left most three characters except the first sector.
Bookmarks