At A2, try this with CSE

=IFERROR(MAX(--((COLUMN($B:$AF)-1)<=LARGE(IF(MID(CONCAT(--NOT(ISBLANK($B2:$AF2))),ROW($A$1:$A$20),6)="111111",ROW($A$1:$A$20),""),1)+5)*--((COLUMN($B:$AF)-1)>=(LARGE(IF(MID(CONCAT(--NOT(ISBLANK($B2:$AF2))),ROW($A$1:$A$20),6)="111111",ROW($A$1:$A$20),""),1)))*$B2:$AF2),"Not Available")