Repeat data in Null rows based on Page #

[msjac01]

Hi Alteryx users -

Does anyone have any advice on populating the null cells based on the above row for the the attached data set? I was attempting to use the multi-row tool but wasn't getting the desired results.

Thanks!

[AGilbert]

The expression for the multi-row tool should be "if isnull([Invoice Date]) then [row-1:Invoice Date] else [Invoice Date] endif". The multi-row tool only works on one field at a time. 

[Yoshiro_Fujimori]

Hi @msjac01 ,

There may be a better way, but basically you can use Cross Tab Tool and Transpose Tool to apply Multi-Row Formula Tool to multiple columns.

I hope this helps. Good luck.

Workflow

[msjac01]

Hi there,

I added this formula and attached are the before and after results. Looks like it doesn't like the 'Page' column