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:

[TABLE="width: 447"]
<colgroup><col></colgroup><tbody>[TR]
[TD]DC METRO DEPARTURES OVER TOPPS/EBONY PLEASE FILE:[/TD]
[/TR]
[TR]
[TD]SWANN..BROSS.J42.RBV..LLUND..BAYYS..PUT..DIRECT[/TD]
[/TR]
[TR]
[TD]SWANN..BROSS.J42.RBV..LLUND..BAYYS..PUT..DIRECT[/TD]
[/TR]
[TR]
[TD]DC METRO DEPARTURES OVER ALLEX PLEASE FILE:[/TD]
[/TR]
[TR]
[TD]SWANN..BROSS.J42.RBV..LLUND..BAYYS..PUT..WITCH..DIRECT[/TD]
[/TR]
[TR]
[TD]DC METRO DEPARTURES OVER BRADD/KANNI PLEASE FILE:[/TD]
[/TR]
[TR]
[TD]AGARD..SIE.J121.SHLEP..ACK..DIRECT[/TD]
[/TR]
[TR]
[TD]AGARD..SIE.J121.SHLEP..ACK..DIRECT[/TD]
[/TR]
[TR]
[TD]OR SWANN..BROSS.J42.RBV..ACK..DIRECT[/TD]
[/TR]
[TR]
[TD]OR SWANN..BROSS.J42.RBV..ACK..DIRECT[/TD]
[/TR]
[TR]
[TD]DC METRO DEPARTURES OVER WHALE PLEASE FILE:[/TD]
[/TR]
[TR]
[TD]AGARD..SIE.J121.SHLEP..YAHOO..DIRECT[/TD]
[/TR]
[TR]
[TD]OR SWANN..BROSS.J42.RBV..YAHOO..DIRECT[/TD]
[/TR]
[TR]
[TD]DC METRO DEPARTURES OVER DOVEY PLEASE FILE:[/TD]
[/TR]
[TR]
[TD]AGARD..SIE.B24.LYNUS..LARGE..DIRECT

REQUIRED TEXT OUTPUT:

[TABLE="width: 393"]
<colgroup><col></colgroup><tbody>[TR]
[TD]DC METRO DEPARTURES OVER TOPPS/EBONY PLEASE FILE:[/TD]
[/TR]
[TR]
[TD]SWANN..BROSS.J42.RBV..LLUND..BAYYS..PUT TOPPS[/TD]
[/TR]
[TR]
[TD]SWANN..BROSS.J42.RBV..LLUND..BAYYS..PUT EBONY[/TD]
[/TR]
[TR]
[TD]DC METRO DEPARTURES OVER ALLEX PLEASE FILE:[/TD]
[/TR]
[TR]
[TD]SWANN..BROSS.J42.RBV..LLUND..BAYYS..PUT..WITCH ALLEX[/TD]
[/TR]
[TR]
[TD]DC METRO DEPARTURES OVER BRADD/KANNI PLEASE FILE:[/TD]
[/TR]
[TR]
[TD]AGARD..SIE.J121.SHLEP..ACK BRADD[/TD]
[/TR]
[TR]
[TD]AGARD..SIE.J121.SHLEP..ACK KANNI[/TD]
[/TR]
[TR]
[TD]OR SWANN..BROSS.J42.RBV..ACK BRADD[/TD]
[/TR]
[TR]
[TD]OR SWANN..BROSS.J42.RBV..ACK KANNI[/TD]
[/TR]
[TR]
[TD]DC METRO DEPARTURES OVER WHALE PLEASE FILE:[/TD]
[/TR]
[TR]
[TD]AGARD..SIE.J121.SHLEP..YAHOO WHALE[/TD]
[/TR]
[TR]
[TD]OR SWANN..BROSS.J42.RBV..YAHOO WHALE[/TD]
[/TR]
[TR]
[TD]DC METRO DEPARTURES OVER DOVEY PLEASE FILE:[/TD]
[/TR]
[TR]
[TD]AGARD..SIE.B24.LYNUS..LARGE DOVEY

As you can see it is a bit messy. Well for my small brain!!!

Thanks all.
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]