Hi, i have a column with following data Store Items 22 1001 abc, 1002 pqr, 1003 tuv 33 1004 def, 1005 xyz And i want to split the column and have the data as follows. Store Item_Id Item_name 22 1001 abc 22 1002 pqr 22 1003 tuv 33 1004 , def 33 1005 xyz ... View more