Formula to transfer data from one range of cells to another based on conditions

See attached:

helper column in Q

=IF(M4<0,B4&COUNTIFS($M$4:M4,"<"&0,$B$4:B4,B4)&IF(C4=1,"070803041110","030407081011"),"")

to give results in form

yyyynaabbccddeeff

yyyy+ year from B

n=count of "Upsets" (incremented for one in each year)

aa=column number for data in R

bb=column number for dat in ss

etc

In R! and copy across

=INT((COLUMNS($R:R)-1)/6)+1

in R4

=IFERROR(INDEX($A$4:$K$200,MATCH($O4&R$1&"*",$Q$4:$Q$200,0),MID(INDEX($Q$4:$Q$200,MATCH($O4&R$1&"*",$Q$4:$Q$200,0)),6,2)+0),"")


Repeated for columns S-U changing highlighted by 2 each time i.e. 8,10,12

in V4

=IFERROR(INDEX($A$4:$K$200,MATCH($O5&V$1&"*",$Q$4:$Q$200,0),MID(INDEX($Q$4:$Q$200,MATCH($O5&V$1&"*",$Q$4:$Q$200,0)),14,2)+0),"") & " - " &IFERROR(INDEX($A$4:$K$200,MATCH($O5&U$1&"*",$Q$4:$Q$200,0),MID(INDEX($Q$4:$Q$200,MATCH($O5&U$1&"*",$Q$4:$Q$200,0)),16,2)+0),"")

Select columns R tot V and copy/paste to next group