Need to split the text into exel within different columns

Help Robot
,
9

@Ram_Shiva_Reddy ,

Check the below Workflow :
DT_Combine_TwoTables.zip (20.5 KB)

Assuming the format remains the same, we could Read the data starting from A2. We could then Filter upto the last row of the First table by using Skip() and Take() methods. The Second table is also retrieved in a similar way but would need to change the column Names as required. We then perform a Join between two tables using the S.No as the key, then keep the required columns in the order required.

A Template file is used to match the required output. However, the Merging of the last row is not done. We could perform this as well if it is really required.

Let us know if this is not working as expected.