Forum Discussion

O_P_Heda's avatar
O_P_Heda
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

 

excel

1 Reply

  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    Nov 07, 2021

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

Resources