Paul I have manually completed the cleaning of the data. The 5 rows dated 02-08-2017 except the first row all others are mixed up. Lines PCD.. & Services are of one date in the 2nd and 3rd row dated 02-08-2017. The fourth row begins from Sent IMPS and the 5th row begins with Recd. IMPS. You have inserted the lines below the date. If you get the lines above the date then I think it will be good. I hope you understood the problem. Where there are multiple lines in one particular date it has to take the first line in the narration and then the next.

I have NOT inserted lines below the dates -I have moved lines above the dates to the end of the rows above - which it seems is where they should be. But, as you haven't provided any screenshots or documents of your own showing what the before and after results should be, we can only guess at your requirements.

In any event, there is a limit to what one can do programmatically with such a mess. If you don't want to use the code I posted, that is up to you.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for your support Paul. I really appreciate it. As I have taken the task in hand, I will keep trying till I find a way to get the data as accurate as possible. Thanks for the code too man.