Parse text file which have single line split into next line

VMR

Hi -

I looking for support to parse a text file with row data splits and comes in the next row. it has to be put back in the same line/upper row. 

Example:

expectation is highlighted data to be put back to the upper row. Appreciate your help. Attached text file to support better.

Parse doc1.txt

grchavarri

Hi @VMR 

The quickest way to do so is using the multirow formula but it depends on the parsing that you are doing to the file. 

find attached an image of the example. I have parsed the .txt file as a flat with a fixed width.

The formula inside the image:

if [Row+1:Field_1]!="" and [Field_1]!=""
then [Row+1:Field_1] else "" endif

Hope it helps,

Let me know with any issues.