Data table cross product

Learning Hub Academy Feedback
1

Hi Team,

Can some one help in below logic to implement-

In the screen shot , i have two columns (highlighted in green)
based on that only other values are being generated.

Column M formulas-
L5D5
L6D5
L7*D5 and so on

Column N formulas-

L5D6
L6D6
L7*D6 and so on

Can someone please help me in this to be solved.
Thanks

image
image1848×488 21.8 KB

2

Hi @Hitesh1

For reference,
For each columns array {“M”,“N”,“O”,“P”,“Q”,“R”} and remember the column index
For each rows array {5,6,7,8,9,10}
then, each value for writing cell is the product of “L” + row and “D” + (5 plus column index)

3

Thanks, I will try this solution