Fill up in Alteryx

Kamran1991

Hi everyone!

Can anyone help me to to fill the blank rows in the a column  from the row given at a lower position. In the attached excel template, you can easily understand my query, once you see Source and Output tabs. 

I want to derive the name of category in for items 1,2 and 3 from the category given for Item_4 and so on.

Your help will be highly appreciated.

Thanks,

Kamran

Fill up in alterys.xlsx

terry10

One easy way is to reverse sort, then use a multirow formula of "IIF (isnull([Category]), [Row-1:Category], [Category])". See attached.

fill up.yxmd