3 Replies Latest reply: May 2, 2016 8:43 AM by Onno van Knotsenburg RSS

    How to convert data in single cell into multiple cell

    Naveen N

      hi this is naveen i am new to qilk view i need to get the output like which i displayed below as i have values in single cell i hav to seprate it can u please help me 

       

       

      CITY
      REET KARAIKAL-609602. Pondi
      REET KARAIKAL-609602. . Pondi
      , PUDUCHERRY-605010 west
      , PUDUCHERRY-605010 west
      COIMBATORE-641006 CMB
      COIMBATORE-641018
      COIMBATORE-641018
      METTUPALAYAM-641301 MTP
      METTUPALAYAM-641302

            

       

       

       




      Ouput:

      City
      PinCode
      REET KARAIKAL
      609602
      PUDUCHERRY
      605010
      COIMBATORE
      641006
      COIMBATORE
      641018
      METTUPALAYAM
      641301
      METTUPALAYAM
      641302