Split multiple values in a single cell to one cell each

Help
, , ,
1

Hi everyone,
I have an excel sheet in which there are multiple values in a single cell and I have column values corresponding to that cell value.Can you help me put a single value in single cell for every column.I am attaching the excel sheet.Hope you could help me as soon as possible.
Thank You.Drawing Register.xlsx (295.5 KB)

2

I don’t think this will solve your issue, but give a try

  1. Read the excel and store in data table
  2. Use output data table activity to convert it to string
  3. Use generate data table activity to make the string into a datatable which will convert the single cell value to all the cells based on the seperator you provide
  4. Write it back to data table
1 Like
3

Thank you for the reply.I will surely try it out and then let you know