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)
I don’t think this will solve your issue, but give a try
- Read the excel and store in data table
- Use output data table activity to convert it to string
- 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
- Write it back to data table
Thank you for the reply.I will surely try it out and then let you know