Deleting unwanted empty row cells

[Gsiva3]

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

INPUT
A	B	C	D
AA	ko	QW	MH
	kl		NB
CD		DF	VG
GB	jn	GV
HJ	po	BH	YT
Remain	Remain	Remain	Remain

OUTPUT
A	B	C	D
AA	ko	QW	MH
CD	kl	DF	NB
GB	jn	GV	VG
HJ	po	BH	YT
Remain	Remain	Remain	Remain

[cjaneczko]

Try this workflow. Its a little clunky, but yields the desired results. 

[cjaneczko]

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

[Gsiva3]

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?

[SPetrie]

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?