A dynamic array.
Formula:
=LET(
a,C30:C33,da,E30:J33,ra,SEQUENCE(ROWS(a)),Pa,INDEX(a,,1),Ta,INDEX(C28,ra^0,),fa,HSTACK(Pa,Ta,da),
b,C38:C41,db,E38:J41,rb,SEQUENCE(ROWS(b)),Pb,INDEX(b,,1),Tb,INDEX(C36,rb^0,),fb,HSTACK(Pb,Tb,db),
c,C46:C49,dc,E46:J49,rc,SEQUENCE(ROWS(c)),Pc,INDEX(c,,1),Tc,INDEX(C44,rc^0,),fc,HSTACK(Pc,Tc,E46:J49),
SORT(VSTACK(fa,fb,fc),1,1))
Ensure that there is NOTHING in the cells where the results are going to spill out.
Bookmarks