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.