Excel Column Value Transformation

Hi All,
We have a new requirement where in some excel columns have multiple Activity values separated by “/” i.e. the column can be “A-200/B-300/C-400”. We are expecting RPA to segregate the values and create a new excel file. The new excel file will have columns like “A”,“B” and “C”. The column ‘A’ will have value 200, column ‘B’ will have 300 and column ‘C’ will have 400.Attached is sample excel for the input and expected output.Excel_Column_Value_Split.xlsx (9.0 KB)

Thanks,
Sarayu

@sarayu Please check below workflow.

Exp.xaml (15.4 KB)