SOLVED

# Create a column based on numbers

Copper Contributor

# 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

4 Replies

# Re: Create a column based on numbers

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.

best response confirmed by saintlouis25 (Copper Contributor)
Solution

# Re: Create a column based on numbers

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

# Re: Create a column based on numbers

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

# Re: Create a column based on numbers

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

Accepted Solutions
best response confirmed by saintlouis25 (Copper Contributor)
Solution

# Re: Create a column based on numbers

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