Trim data to all one row from adjacent rows .

Hello all ,

In this sheet I am trying to get data from 3 x rows (all rows adjacent to each other) that will give me the results I have in col O .

Of the eight results I need from cols G to N , I have already adapted 4 x of them with working functions thanks to people from here .
So cols G , H , K and L are resulting for me . Filtering col O shows the results I have filled in manually , this should be what rows will look like after repairs .

Some points of interest which will help in this task are .

The data after I have cleaned it up will always be in this same format .
The horse names appear twice , so either could be used but I am using the one with tab# (always left of a full stop) and barrier (to the right of name always in brackets) .

The jockeys name always has a letter J next to it to the left .
The trainers name always has a letter T next to it to the left .
The claim if there is one will be to the very right of the name (in brackets) , example (a1) , (a3) , (a0.5) . The brackets and letter (a) not needed .

Col N result I can do with minus col M from col L .

I have tried to adapt other trim type functions but never give a whole correct result .
Thanks .

Please try at

G2
=IF(H2="","",--LEFT(SUBSTITUTE(INDEX($D$2:$D$99,MATCH(H2,$D$2:$D$99,)+1),"."," "),2))

H2
=IFERROR(INDEX($D$2:$D$99,AGGREGATE(15,6,ROW($D$2:$D$99)/ISNUMBER(FIND(CHAR(160),$D$2:$D$99)),ROWS(H$2:H2))-2),"")

I2:J2
=IF($H2="","",TRIM(MID(SUBSTITUTE(INDEX($D$2:$D$99,MATCH($H2,$D$2:$D$99,)+COLUMNS($H2:I2)),"(",REPT(" ",99)),2,99)))

K2:L2
=IF($H2="","",-MID(SUBSTITUTE(INDEX($D$2:$D$99,MATCH($H2,$D$2:$D$99,)+COLUMNS($K2:K2)),"(",REPT(" ",99)&"("),99,99))

Wow , just give me a second while I get off the floor again from you answers ,results ,post .
Astounding in a good way is all I can say .

I entered another 99 pieces of data totally different and result again perfect . I lose the race number but that's insignificant .

My question is I supplied only 2 x races as a sample sheet , I checked yesterdays meetings in New Zealand and I see there would of been 700 rows to process .

Will the functions still work if I changed all of them to say 2000 from 99 . Alternatively my second question is would I have to put in correct 700 where 99 is . Just trying to predict future sheet row sizes .
Thanks ,

Thanks Bo_Ry , this has made things a lot easier .
Thank you .