conditional new rows

chester12

New Member
Joined
Feb 16, 2014
Messages
38
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 PolybiusRace Type HorseOpen
3:40K Politico4:10K Rastanora(USA)SP RangeTop 3rd
2:40K Flying Fantasy5:10K DaydreamerSP RangeTop 3rd
3:40K Politico4:10K Rastanora(USA)Race Type HorseMaiden

<colgroup><col><col><col></colgroup><tbody>
</tbody>
I need this

4:40K PolybiusRace Type HorseOpen
3:40K PoliticoSP RangeTop 3rd
4:10K Rastanora(USA)SP RangeTop 3rd
2:40K Flying FantasySP RangeTop 3rd
5:10K DaydreamerSP RangeTop 3rd
3:40K PoliticoRace Type HorseMaiden
4:10K Rastanora(USA)Race Type HorseMaiden

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

thanks a lot
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,109,543
Messages
5,529,456
Members
409,879
Latest member
Aussie_Excel_Wanna_Be
Top