Thread: Flow sequence
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Freshman Freshman is offline
external usenet poster
 
Posts: 158
Default Flow sequence

Dear experts,

I got an external table showing the flows of parcels. For example, column A
is for source locations and colum B is for destination locations.

Parcel 123 (for example)

From Shop To Shop

A1 B7
..
..
..
..
B7 C10
..
..
C10 D9

If there are more than 100 rows of source locations and I want to see the
flow of a parcel at one glance, such as:

Shop A1 -- Shop B7 -- Shop C10 -- Shop D9.

Is there a way to do it? Please kindly advise.

Thanks in advance