Forum Discussion
Solved
Create a column based on numbers
Image shows Column ID and N which summarized fifth column ID in my case i need to construct column E using the values presented in ID, N, is there a formula there? Thank you
saintlouis25 Option using dynamic sheet array functions:
=LET(ID,A2:A6,nn,B2:B6,TOCOL(MAKEARRAY(ROWS(ID),MAX(nn),LAMBDA(r,c,IF(c>INDEX(nn,r),NA(),INDEX(ID,r)))),3,FALSE))
saintlouis25 Option using dynamic sheet array functions:
=LET(ID,A2:A6,nn,B2:B6,TOCOL(MAKEARRAY(ROWS(ID),MAX(nn),LAMBDA(r,c,IF(c>INDEX(nn,r),NA(),INDEX(ID,r)))),3,FALSE))
Nice im gonna check it right now. Thank you so much