MS office Excel 365

New Contributor

Resp Sir, 

Sadar Pranam/Nameste.


plz guide some formula to prepare  list in one column from two columns list in continuous


1 Reply


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