Forum Discussion
Need assistance in having contents of one column encompass all contents of another
Hello, I am looking to build out functionality to have each cell in "Alpha" connect to all cells in "Beta", just like the example below. This needs to be flexible enough to adjust for varying amo...
As variant
=LET(
alpha, Table1[Alpha],
beta, Table2[Beta],
a, COUNTA(alpha),
b, COUNTA(beta),
k, SEQUENCE(a*b),
aInd, (k-1)/b+1,
bInd, MOD(k-1,b)+1,
firstColumn, IF(INT(aInd)+1=aInd+1, INDEX(alpha, aInd), ""),
secondColumn, INDEX(beta, bInd),
IF( {1,0}, firstColumn, secondColumn)
)- Thank you, will see if this works
