IF + AND (or vlookup formula?)

Hi guys,

I need a help with my spreadsheet (it's attached below for reference)

I have data populated by scraping VBA macro in range J2:S9

Table in range A1:G9 should automatically "process" with formulas data according to my needs. Each row represents separate game. Under each game there will be either one (the same) or two (different) lines available

For example for third row (game id 2) line is the same (0.5). Therefore cell B3 should display this line (0.5) and in next cell (C3) display the highest value from respective columns =MAX(K3, N3, Q3). Cell D3 should do the same but for an away team so =MAX(L3, O3, R3) (in this case for cell C2 correct number to display is 0.93 and for cell D2 it's 1). Cells E2, F2 and G2 in this scenario should be auto-populated with "n/a" text.

However it gets tricky for rows like second row (game id 1). In this case line A is the same as line B but different than line C, therefore for each line maximum values have to be treated separately (formula must also deal with similar situations when for example Line A is the same as line C but different than line B) therefore cell B2 should display one unique line (0/0.5) cell C2 and D2 should display the highest respective value (so either K2 or N20 for C2 and L2 or O2 for D2). Then another line should be auto-populated by formula in cell E2 (0.5 from cell P2) and therefore F2 will be simply a value from cell R2 and H2=R2

I hope it does make sense, attaching the spreadsheet below