I am having a table as shown below:
|User 1||23||Pune||This is||UiPath|
|a description for|
|User 2||24||Mumbai||Demo of re||UiPath|
|User 3||25||London||UiPath is a autom||UiPath|
|User 4||26||Boston||User four be||UiPa|
|longs to the Boston||th|
|User 5||27||Delhi||This is the la||Ui|
|st example to||Pat|
|make this line comple||h|
And I wish to have a table as shown below:
|User 1||23||Pune||This is a description for user one||UiPath|
|User 2||24||Mumbai||Demo of requirements||UiPath|
|User 3||25||London||UiPath is a automation tool||UiPath|
|User 4||26||Boston||User four belongs to the Boston in USA||UiPath|
|User 5||27||Delhi||This is the last example to make this line completed||UiPath|
I hope the requirement is clear, as I want to do the data massage such that data moving to multiple lines in the table is appended to previous lines.
Also There are empty lines in the raw data after each and every record, I wanted to remove that as well.
I know I can do it wit some messy unreliable complex string manipulations, but I want some clean and simple logic to satisfy these conditions.
Thanks and Regards,