conditional new rows

[chester12]

I have this..time1,2,3 or more times followed by horse names for each time in col1

K is a short for the course..it could be more than 1 letter

I need data in cols 2 and 3 repeated for each horse in col1..each time+ horse must have a separate row

4:40K Polybius	Race Type Horse	Open
3:40K Politico4:10K Rastanora(USA)	SP Range	Top 3rd
2:40K Flying Fantasy5:10K Daydreamer	SP Range	Top 3rd
3:40K Politico4:10K Rastanora(USA)	Race Type Horse	Maiden

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

I need this

4:40K Polybius	Race Type Horse	Open
3:40K Politico	SP Range	Top 3rd
4:10K Rastanora(USA)	SP Range	Top 3rd
2:40K Flying Fantasy	SP Range	Top 3rd
5:10K Daydreamer	SP Range	Top 3rd
3:40K Politico	Race Type Horse	Maiden
4:10K Rastanora(USA)	Race Type Horse	Maiden

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

thanks a lot