Forum Discussion

Copper Contributor

Nov 07, 2021

MS office Excel 365

Resp Sir, Sadar Pranam/Nameste. plz guide some formula to prepare list in one column from two columns list in continuous

Silver Contributor

Nov 07, 2021

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))