Deleting unwanted empty row cells

Question

I have 4 columns named as A,B,C,D.  have one empty row value in one column and on some of the columns I have 2 or 3 empty values. So the thing is the empty row above the cell value "Remain" has to be retained and all the other empty row values has to be removed from all the columns.

Please help me on this

INPUTABCDAAkoQWMH kl NBCD DFVGGBjnGV HJpoBHYT    RemainRemainRemainRemain

OUTPUTABCDAAkoQWMHCDklDFNBGBjnGVVGHJpoBHYT    RemainRemainRemainRemain

SPetrie · Answer

Is it always the last two rows that need to remain static? Can we just split those off, do the row shuffle and then tack them back on?

delete rows.yxmd

Gsiva3 · Answer

Yes. And I not only have 4 column. In my actual input I have more than 20 column. Hence it is not possible to separate all the 20 columns using select tool. Is there any other way to do this?

cjaneczko · Answer

In reviewing it looks like the Data Cleansing tool is reordering the data in each field. The flow I posted needs some tweaking.