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))
You can try Power Query. In the attached file you can add ID and N in the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh in order to update the green result table.
Thank you very nice attractive answer o couldnt imagine this solution. Let me see.