1 Reply Latest reply: Aug 27, 2018 4:23 AM by Jaume Criballés Faja RSS

    convert one column data into two column with help of delimiter

    xxxxx yyyyy

      i have data like

       

      Flight code,     

      JJ-DL,
      IB-UA
      LH-UA
      BA-UA
      LH-AA
      AA-UA
      QZ-SQ
      UA-WS
      UA-AI
      AA-UA
      UA-DY

      I want dived it into 

       

      Flight1, flight2

      JJ,DL,
      IB,UA
      LH,UA
      BA,UA
      LH,AA
      AA,UA
      QZ,SQ
      UA,WS
      UA,AI
      AA,UA
      UA,DY