0

I have the following table on the left with several rows and columns as input.

I would like to obtain a table on the right by formulas.

Ideally, I'm looking for one dynamic array formula in J3, which takes D3:G3 and C4:C6 as arguments.

One dynamic array formula in J3 and another one in K3 will also be acceptable.

A solution with LAMBDA function would be second best (though you could still propose one), because not everyone is using beta channel.

Could anyone help?

enter image description here

Improve this question

1 Answer 1

Reset to default
4

With LET:

=LET(x,ROWS(C4:C6),y,COLUMNS(D3:G3),z,SEQUENCE(x*y)-1,CHOOSE({1,2},INDEX(D3:G3,1+MOD(z,y)),INDEX(C4:C6,1+INT(z/y))))

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

nice solution, thank you.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.