Forum Discussion

  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    Oct 02, 2024

    anupambit1797 

    Staying within the Excel formula environment, you could have

    = TOCOL(
    HSTACK(
      TEXTBEFORE(pairs,","), 
      TEXTAFTER(pairs,",")
    )
  )

    The more obvious use of TEXTSPLIT that would have mirrored the PowerQuery operation more closely fails because of Microsoft's well-known 'array of arrays' implementation error.

     

    • anupambit1797's avatar
      anupambit1797
      Iron Contributor
      Oct 02, 2024

      Thanks , PeterBartholomew1 could you please help to provide the result sheet with the formula,

       

      I tried the one you suggested but, seem to throw me a #NUM err.

       

      Thanks in Advance,

      Br,

      Anupam

       

      • Lorenzo's avatar
        Lorenzo
        Silver Contributor
        Oct 02, 2024

        anupambit1797 

         

        Replace YourTableName belows with your actual Table name:

        = TOCOL(
    HSTACK(
      TEXTBEFORE(YourTableName[RLC-NR_Sequence Numbers(Subcell-9)],","),
      TEXTAFTER(YourTableName[RLC-NR_Sequence Numbers(Subcell-9)],",")
    )
  )

         

         

Resources