Separating Data into new Rows

[Ggow1990]

Hi,

I have over 4000 rows of data. The data consists of flight routes.
For example, Edinburgh/London.

However, I also have lines where the route might be Edinburgh/London/Dubai/Sydney etc.

I want to separate all rows so that each row only has one flight on it, eg Edinburgh/London on one line then London/Dubai on another line and so on.

Is there any macros that would be able to do this?

Any help is much appreciated