Splitting by column

Help
1

Hello I could not split it by column, so basically what am I doing is to base on the title and split it into the respective column and append to it so hopefully can get some idea as I cant seem to split it by column
image

2

Hello Eugina,
Do one thing store this data in an excel file. And read that file using Excel application scope activity. In it use Read Column Activity and mention the name of the Column like A1 or A2. This will provide you an ienumerable variable. Now use the for each loop and add each value in an array. Now your array is ready to use.