Problem with the format source

Hello everyone,

I have a database that have some information split in two rows, what I need it is a flow that can correct that information, I hope anyone can help me.

The major problem  is, the information does not have an identifier like you can see at the attach, in the row1 I have a part of the email address, and in row 2 another part.


in the file attached


I'm not sure if there is a more elegant solution, but I would try: "Column to Grid" > "String Manipulation".   The first node will pick up your column fragment and put it into the correct row.  The 2nd will let you combine the two columns. Does that help?