Create a column based on numbers

[saintlouis25]

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

[#2]

@saintlouis25 

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.

[#3 · Accepted solution]

@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))

[#4]

Nice im gonna check it right now. Thank you so much

[#5]

Thank you very nice attractive answer o couldnt imagine this solution. Let me see.