Multirow formula inside formula need to fill blank cells but with pyramidal format

[Mosi05061989]

Hi am trying to get this solved, i have a column with different levels and i need to split in different columns the information, basically what i used is :

1.- a formula tool in which i put conditional levels for each new column created for example a 

for level 1 i use 

if [F1] = "mochila" then [F1]
else Null() endif

 for level 2 same 

if [F1] = "estuche" then [F1]

elseif [F1] = "libreta" then [F1]
else Null() endif

and then in order to fill all blank spaces on each new columns

i use a a multi row formula with below formula

if isnull([nivel1]) then [row-1:nivel1] else [nivel1] endif

my issue with this is that on every change of category i have wrong information from the cell before and i need to be in blank

is it possible to do a multi row formula inside a formula?

or is there a way to fill blank spaces?

this is what i would like to do as formula

IF isnull ([nivel 3])
then (IF [Row-1:nivel2] equals [nivel2] then [row-1:nivel1] ) else 0
endif

[PhilipMannering]

You could try selecting "Group By" fields for every level less than the current level. So if you're filling down "nivel 5", in the MultiRow Tool Group by: nivel 1, nivel 2, nivel 3 and nivel 4 and be sure to select "Null for records that don't exists".