replace text directly above if text string is "XXX"

Question

Hi all,

Is there a reasonable way to replace a certain text string with text above? Thanks.

example below:

replace "asabove" with text that's in the cell above it if its a different text string.

in excel I could do a "fill down( =, alt+enter key)"...is there something similar in Alteryx?

Sample:

MediumArgentina,Belgium,Brazil,Colombia,France,Netherlands,Japan,Singapore,SwedenAsaboveArgentina,Australia,Belgium,China,France,Germany,India,Italy,Korea,Luxembourg,Netherlands,Philippines,Russia,Sweden,Switzerland,Taiwan,Thailand,UnitedStatesAsaboveAsaboveAsabove

ideal results:

MediumArgentina,Belgium,Brazil,Colombia,France,Netherlands,Japan,Singapore,SwedenArgentina,Belgium,Brazil,Colombia,France,Netherlands,Japan,Singapore,SwedenArgentina,Australia,Belgium,China,France,Germany,India,Italy,Korea,Luxembourg,Netherlands,Philippines,Russia,Sweden,Switzerland,Taiwan,Thailand,UnitedStatesArgentina,Australia,Belgium,China,France,Germany,India,Italy,Korea,Luxembourg,Netherlands,Philippines,Russia,Sweden,Switzerland,Taiwan,Thailand,UnitedStatesArgentina,Australia,Belgium,China,France,Germany,India,Italy,Korea,Luxembourg,Netherlands,Philippines,Russia,Sweden,Switzerland,Taiwan,Thailand,UnitedStatesArgentina,Australia,Belgium,China,France,Germany,India,Italy,Korea,Luxembourg,Netherlands,Philippines,Russia,Sweden,Switzerland,Taiwan,Thailand,UnitedStates

acastelazo · Accepted Answer

You could use the multi-row tool to copy the row above if the current row = "asabove"