How to fill blank rows

[Pandey19]

Hi,

I've my input data like below

ACCOUNT TYPE	ACCT ALIAS	N
Asset	A1019940 - Cash And Float	0
	A1020320 - Due
	A1695000 - Total Loans	2376050404
	A2121900 - Goodwill	1298504
	A2295000 -not subject to currency revaluation	0
	A2893000 -  subject to currency revaluation	7446591.27
	A1100980 - Total Int	0
Asset Total		2384795499
	Ties to support schedule	A3 & A4
Sum of YTD BAL		FLAG
ACCOUNT TYPE	ACCT ALIAS	N
Liability	A4590000 - Total long-term debt	0
	A4495000 - Accrued Expense	0
Liability Total		0
	Ties to support schedule	A3 & A4
Owner's Equity	A4948800 - Equity	0
Owner's Equity Total		0
	Ties to support schedule	A3 & A4

Under one Account type, there are some ACCT ALIAS and N. And account type appears only once in their respective first record

Is it possible to change this to below output?

ACCOUNT TYPE	ACCT ALIAS	N
Asset	A1019940 - Cash And Float	0
Asset	A1020320 - Due
Asset	A1695000 - Total Loans	2376050404
Asset	A2121900 - Goodwill	1298504
Asset	A2295000 -not subject to currency revaluation	0
Asset	A2893000 -  subject to currency revaluation	7446591.27
Asset	A1100980 - Total Int	0
Asset Total		2384795499
	Ties to support schedule	A3 & A4
Sum of YTD BAL		FLAG
ACCOUNT TYPE	ACCT ALIAS	N
Liability	A4590000 - Total long-term debt	0
Liability	A4495000 - Accrued Expense	0
Liability Total		0
	Ties to support schedule	A3 & A4
Owner's Equity	A4948800 - Equity	0
Owner's Equity Total		0
	Ties to support schedule	A3 & A4

[AkimasaKajitani]

Hi @Pandey19 

In this case, you can use Multi-Row Formula tool.

But it is needed the little complex formula.

This formula will work well.

IF IsEmpty([ACCOUNT TYPE]) AND Contains([Row-1:ACCOUNT TYPE],"Total") THEN [ACCOUNT TYPE]
ELSEIF IsEmpty([ACCOUNT TYPE]) THEN [Row-1:ACCOUNT TYPE]
ELSE [ACCOUNT TYPE] ENDIF

[Luke_C]

Hi @Pandey19 

You can use a multi-row tool:

[SPetrie]

A multi-row formula would be able to handle it.

I copied and pasted your sample data so it may not be formatted exactly as you have it, but the formula will be essentially the same.

I did a data cleansing tool for that first column ,so my formula is looking for empty cells, yours may be null so alter it as you see fit.

The formula I used is

if isempty([ACCOUNT TYPE]) and !isempty([Row-1:ACCOUNT TYPE]) and !contains([Row-1:ACCOUNT TYPE],"Total") then [Row-1:ACCOUNT TYPE] else [ACCOUNT TYPE] endif

In plain terms, if the cell is empty and the one above it isnt and the one above doesnt have the word total it it, copy the cell from above. If none of those conditions are true, use whatever is currently in the cell already, be it blank or not.