I checked the data after running the code. Only that particular row is right. All the other rows are not affected by the code. This is just a sample data. Imagine where there are more than 500 rows of data, then I will have to clean each and every row to get it right. If the sample data works accurately, I could try it on the original data.
As the document is converted into pdf and I am trying to convert the pdf to document once again, there has to be some way to get each transaction separated from each other at each change in date. I am just trying to know and understand the pattern how it was done.
The option in word document is also giving the same result if I convert it to table.