Using Recursive REDUCE() function:
=LET(
_Data, A2:N4,
IFNA(DROP(REDUCE("",SEQUENCE(ROWS(_Data)),LAMBDA(a,b,
LET(c,CHOOSEROWS(_Data,b),d,DROP(c,,1),
VSTACK(a,IFNA(HSTACK(@c,FILTER(VSTACK(B1:N1,d),(d>0)*(d<15))),""))))),1),""))
CAVEAT: It is highly suggested not to use the whole empty ranges in the formulas, this is because the functions will be iterating through the empty cells thus making it slower slower and slower, thus affecting the performance.
Using Recursive REDUCE() function:
=LET(
_Data, A2:N4,
IFNA(DROP(REDUCE("",SEQUENCE(ROWS(_Data)),LAMBDA(a,b,
LET(c,CHOOSEROWS(_Data,b),d,DROP(c,,1),
VSTACK(a,IFNA(HSTACK(@c,FILTER(VSTACK(B1:N1,d),(d>0)*(d<15))),""))))),1),""))
CAVEAT: It is highly suggested not to use the whole empty ranges in the formulas, this is because the functions will be iterating through the empty cells thus making it slower slower and slower, thus affecting the performance.
Using Recursive REDUCE() function:
=LET(
_Data, A2:N4,
IFNA(DROP(REDUCE("",SEQUENCE(ROWS(_Data)),LAMBDA(a,b,
LET(c,CHOOSEROWS(_Data,b),d,DROP(c,,1),
VSTACK(a,IFNA(HSTACK(@c,FILTER(VSTACK(B1:N1,d),(d>0)*(d<15))),""))))),1),""))
CAVEAT: It is highly suggested not to use the whole empty ranges in the formulas, this is because the functions will be iterating through the empty cells thus making it slower slower and slower, thus affecting the performance.
Using Recursive REDUCE() function:
=LET(
_Data, A2:N4,
IFNA(DROP(REDUCE("",SEQUENCE(ROWS(_Data)),LAMBDA(αa,δb,
LET(φc,CHOOSEROWS(_Data,δb),εd,DROP(φc,,1),
VSTACK(αa,IFNA(HSTACK(@φ@c,FILTER(VSTACK(B1:N1,εd),(ε>0d>0)*(ε<=15d<15))),""))))),1),""))
CAVEAT: It is highly suggested not to use the whole empty ranges in the formulas, this is because the functions will be iterating through the empty cells thus making it slower slower and slower, thus affecting the performance.
Using Recursive REDUCE() function:
=LET(
_Data, A2:N4,
IFNA(DROP(REDUCE("",SEQUENCE(ROWS(_Data)),LAMBDA(α,δ,
LET(φ,CHOOSEROWS(_Data,δ),ε,DROP(φ,,1),
VSTACK(α,IFNA(HSTACK(@φ,FILTER(VSTACK(B1:N1,ε),(ε>0)*(ε<=15))),""))))),1),""))
CAVEAT: It is highly suggested not to use the whole empty ranges in the formulas, this is because the functions will be iterating through the empty cells thus making it slower slower and slower, thus affecting the performance.
Using Recursive REDUCE() function:
=LET(
_Data, A2:N4,
IFNA(DROP(REDUCE("",SEQUENCE(ROWS(_Data)),LAMBDA(a,b,
LET(c,CHOOSEROWS(_Data,b),d,DROP(c,,1),
VSTACK(a,IFNA(HSTACK(@c,FILTER(VSTACK(B1:N1,d),(d>0)*(d<15))),""))))),1),""))
CAVEAT: It is highly suggested not to use the whole empty ranges in the formulas, this is because the functions will be iterating through the empty cells thus making it slower slower and slower, thus affecting the performance.
Using Recursive REDUCE() function:
=LET(
_Data, A2:N4,
IFNA(DROP(REDUCE("",SEQUENCE(ROWS(_Data)),LAMBDA(α,δ,
LET(φ,CHOOSEROWS(_Data,δ),ε,DROP(φ,,1),
VSTACK(α,IFNA(HSTACK(@φ,FILTER(VSTACK(B1:N1,ε),(ε>0)*(ε<=15))),""))))),1),""))
CAVEAT: It is highly suggested not to use the whole empty ranges in the formulas, which not only slows down the working functionality of Excel this is because the functions will be iterating through the empty cells thus making it slower slower and slower, thus affecting the performance.
Using Recursive REDUCE() function:
=LET(
_Data, A2:N4,
IFNA(DROP(REDUCE("",SEQUENCE(ROWS(_Data)),LAMBDA(α,δ,
LET(φ,CHOOSEROWS(_Data,δ),ε,DROP(φ,,1),
VSTACK(α,IFNA(HSTACK(@φ,FILTER(VSTACK(B1:N1,ε),(ε>0)*(ε<=15))),""))))),1),""))
CAVEAT: It is highly suggested not to use the whole empty ranges in the formulas, which not only slows down the working functionality of Excel this is because the functions will be iterating through the empty cells thus making it slower slower and slower, thus affecting the performance.
Using Recursive REDUCE() function:
=LET(
_Data, A2:N4,
IFNA(DROP(REDUCE("",SEQUENCE(ROWS(_Data)),LAMBDA(α,δ,
LET(φ,CHOOSEROWS(_Data,δ),ε,DROP(φ,,1),
VSTACK(α,IFNA(HSTACK(@φ,FILTER(VSTACK(B1:N1,ε),(ε>0)*(ε<=15))),""))))),1),""))
CAVEAT: It is highly suggested not to use the whole empty ranges in the formulas, this is because the functions will be iterating through the empty cells thus making it slower slower and slower, thus affecting the performance.