How to masage excel data and bring it to certain Format

I have excel data like this :


Each Cell has 2 lines, 1st line is the message and second line the time, The format in which I need the data is :


Basically I need to bifurcate the message and time in 2 different columns.

Kindly suggest

1 Like


Hope the following sample helps you.

dt = dt.AsEnumerable.Select(Function(r) dt.Clone.LoadDataRow(r(0).ToString.Split(vbCrLf.ToCharArray,StringSplitOptions.RemoveEmptyEntries),False)).CopyToDataTable (8.3 KB)


1 Like

Hii @Ishan_Shelke ,
Please check this workflow (2.0 KB)

Hope this helps :slightly_smiling_face:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.