Forum Discussion
Recursive Lambda: Unpacking LET function
RecentlyTwifoo posted the FIFO Inventory challenge, and PeterBartholomew1 ventured "shouldn't take lori_m more than a few minutes to write a recursive Python script to reduce any LET function back to...
rachel
Probably was my mistake, excuse me!
=TEXTSPLIT(
ARRAYTOTEXT(
MAP(
SEQUENCE(ROWS(A1:A30); 1; 1; 1);
LAMBDA(row_index;
LET(
data; A1:B30;
xs; TEXTSPLIT(INDEX(data; row_index; 1); ", ");
ys; TEXTSPLIT(INDEX(data; row_index; 2); ", ");
ARRAYTOTEXT(xs & "-" & TRANSPOSE(ys))
)
)
)
);
;
"; "
)This works perfect, many thanks! 🙂
