Information splitted in two rows


I have a database that have information splitted in two rows, as you can see at the attach, what I need is a flow that can correct that information, and write the two rows in just only one.

I hope someone can help me

Assuming that the rows with the second part of the splits always follow the first ones, you can use a counter. you can then isolate the rows that contain cells that need to be attached at the end of the ones above and you can diminish the counter by 1. groupby will then allow you to merge the content of the rows.

I am attaching an example 



Great thanks it worked very well