LorenzoSilver ContributorJun 15, 2022SolvedStack sequences of various size Hi With Office 365/Windows, how do I generate the Expected dynamic array from the Inputs range? No Power Query nor VBA please, LAMBDA is fine though Thanks Show MoreSampleForSequence.xlsx15 KBmtarlerJun 15, 2022Lorenzo I bet one of those new text manipulation functions may help do this but I don't have beta channel so here is my solution:=LET(in,Inputs,inc,SCAN(0,in,LAMBDA(c,I,I+c)),s,SEQUENCE(SUM(in)),s-XLOOKUP(s,inc+1,inc,0,-1))SampleForSequence.xlsx10 KB
mtarlerJun 15, 2022Lorenzo I bet one of those new text manipulation functions may help do this but I don't have beta channel so here is my solution:=LET(in,Inputs,inc,SCAN(0,in,LAMBDA(c,I,I+c)),s,SEQUENCE(SUM(in)),s-XLOOKUP(s,inc+1,inc,0,-1))SampleForSequence.xlsx10 KB
mtarlerJun 15, 2022Lorenzo I bet one of those new text manipulation functions may help do this but I don't have beta channel so here is my solution:=LET(in,Inputs,inc,SCAN(0,in,LAMBDA(c,I,I+c)),s,SEQUENCE(SUM(in)),s-XLOOKUP(s,inc+1,inc,0,-1))SampleForSequence.xlsx10 KB
Patrick2788Silver ContributorJun 15, 2022Lorenzo Another one:=TEXTSPLIT(REDUCE("",inputs,LAMBDA(a,b,TEXTJOIN(",",1,a,SEQUENCE(b)))),,",")
LorenzoSilver Contributor to Patrick2788Jun 16, 2022Patrick2788 THANKS too. Concise option + it drops REDUCE's initial_value Really appreciated
