Append/Convert undefined column's data into rows in DataTable using Linq

[Jayavignesh_G]

@Sivasees_Rajguru - A Similar /Same Requirement is stated in another post, I would suggested you to go this Solution. Could you Check and let us know if the post was helpful

Need to split the text into exel within different columns

Hello, Please go through the attached image, Here I need to split the text data into excel in different columns. Please help me sorting this data. [Screenshot (21)] Output should be in the format like Work name, Muster roll no, Amount, Work name, Bill no and Amount.