How to remove empty lines from a cell in datatable?

My datatable contains 3 columns. The cells in first column has data in following format:



I want to remove all the empty lines and store it in the same cell. Output should be like this:

How do I do this?

Try to use filter data table activity or else you can apply for each loop on the datatable and on apply if condition in it that if the current value is not empty string same should be copied to a new datatable

Hello @shrutika

Please refer to this workflow i created for you. This might help you :slight_smile:

Excel_Operations (1).xaml (17.1 KB)

Let me know if it helps :slight_smile:

This removes all the spaces in the cell. I need to remove only the empty lines.