Nov 07 2021 01:11 AM
Resp Sir,
Sadar Pranam/Nameste.
plz guide some formula to prepare list in one column from two columns list in continuous
Nov 07 2021 01:09 AM
@O_P_Heda
Some guessing is required to discern the intent of the question. Maybe
= LET( m, ROWS(listA), n, ROWS(listB), k, SEQUENCE(m+n), combined, IF(k<=m,listA, INDEX(listB,k-m)), SORT(combined))
