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

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