I have the same question but the items repeated with a different number of times, determined by the next column. I have tried the formula: =VSTACK(BYROW(B3:B6,LAMBDA(x,TOCOL(IF(SEQUENCE(,OFFSET(x,,1)),x))))) but it didn't work. I attached a photo here for your reference. Please help me out with this. Thank you very much