Copy data from above row when row is empty

[Whooppee]

Hi, 

I am fairly new to Alteryx.  I have been doing searches on this subject and I had tried different suggestions but they didn't work.  

I have a PDF file I have extracted data from.  In the PFD, the account # only shows for the 1st line of invoices the customer has.  I need to copy down the account number to the blank item.  

This is what I need for results. 

Any help would greatly appreciated. 

[ShankerV]

Hi @Whooppee 

Please use Multi row formula tool to achieve the output.

Step 1:  Input

Step 2: 

IF ISNULL([Account])
THEN [Row-1:Account]
ELSE [Account]
ENDIF

Many thanks

Shanker V

[Whooppee]

Hi, 

I didn't get any errors on the formula.  However, the account # didn't copy down and remains blank.  

[MilindG · Accepted solution]

instead of isnull, use isempty and see if that works

[Whooppee · Accepted solution]

Hi, 

That worked!  Thanks.