Combining various rows with data above depending on criteria

[Johnno1980]

Hi All,

I currently have a macro running which is used to create tracks with always changing points. The start points I have managed to multiply by the amount I need but I am having trouble adding the end points because their number of times varies each run depending on how many end points there are. Below I have added what I have to begin with and what the output needs to be. I hope you are able to help and huge thank you in advance.

ORIGINAL TEXT INPUT:

DC METRO DEPARTURES OVER TOPPS/EBONY PLEASE FILE:

SWANN..BROSS.J42.RBV..LLUND..BAYYS..PUT..DIRECT

SWANN..BROSS.J42.RBV..LLUND..BAYYS..PUT..DIRECT

DC METRO DEPARTURES OVER ALLEX PLEASE FILE:

SWANN..BROSS.J42.RBV..LLUND..BAYYS..PUT..WITCH..DIRECT

DC METRO DEPARTURES OVER BRADD/KANNI PLEASE FILE:

AGARD..SIE.J121.SHLEP..ACK..DIRECT

AGARD..SIE.J121.SHLEP..ACK..DIRECT

OR SWANN..BROSS.J42.RBV..ACK..DIRECT

OR SWANN..BROSS.J42.RBV..ACK..DIRECT

DC METRO DEPARTURES OVER WHALE PLEASE FILE:

AGARD..SIE.J121.SHLEP..YAHOO..DIRECT

OR SWANN..BROSS.J42.RBV..YAHOO..DIRECT

DC METRO DEPARTURES OVER DOVEY PLEASE FILE:

AGARD..SIE.B24.LYNUS..LARGE..DIRECT REQUIRED TEXT OUTPUT: DC METRO DEPARTURES OVER TOPPS/EBONY PLEASE FILE: SWANN..BROSS.J42.RBV..LLUND..BAYYS..PUT TOPPS SWANN..BROSS.J42.RBV..LLUND..BAYYS..PUT EBONY DC METRO DEPARTURES OVER ALLEX PLEASE FILE: SWANN..BROSS.J42.RBV..LLUND..BAYYS..PUT..WITCH ALLEX DC METRO DEPARTURES OVER BRADD/KANNI PLEASE FILE: AGARD..SIE.J121.SHLEP..ACK BRADD AGARD..SIE.J121.SHLEP..ACK KANNI OR SWANN..BROSS.J42.RBV..ACK BRADD OR SWANN..BROSS.J42.RBV..ACK KANNI DC METRO DEPARTURES OVER WHALE PLEASE FILE: AGARD..SIE.J121.SHLEP..YAHOO WHALE OR SWANN..BROSS.J42.RBV..YAHOO WHALE DC METRO DEPARTURES OVER DOVEY PLEASE FILE: AGARD..SIE.B24.LYNUS..LARGE DOVEY As you can see it is a bit messy. Well for my small brain!!! Thanks all. <colgroup><col></colgroup><tbody> </tbody>

<colgroup><col></colgroup><tbody>
</tbody>