technical problem

[#1]

Hi Folks ,

I am facing one issue , i have tried all the methods but its not working can you please help on this . 

one column have data like below its there row wise (Original column)

IT Strategy& Architecture BDC India [MITX 999],Corporate & IC Solution Delivery [SVII],

Operations Solution Delivery [SVIA],

Mainframe Service [MLEM],Strategy & Architecture [MLEL]

the above 3 rows i need to split into two columns like below 

1st column

IT Strategy& Architecture BDC India,Corporate & IC Solution Delivery,Operations Solution Delivery,Mainframe Service,Strategy & Architecture 

2nd columns

[MITX 999],[SVII],[SVIA],[MLEM], [MLEL]

please help , working new for impala data lake . Thank You ..!