Forum Discussion
Join the results of two filtered tables in a single range
Hi, I am using the following formula to join the filtered results of two tables. Filter is resulting in 2 rows from 1st table and 10 rows from 2nd table. While the results of 1st table are corr...
assuming you have same number of columns, rest of the formula will be as
...
m, SEQUENCE(,COLUMNS(oddarray)),
IF(k <= oddK,
INDEX(oddarray, k, m),
INDEX(evenarray, k-oddK, m)
)