replace text directly above if text string is "XXX"

[BosKev]

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:

Medium

Argentina,Belgium,Brazil,Colombia,France,Netherlands,Japan,Singapore,Sweden

Asabove

Argentina,Australia,Belgium,China,France,Germany,India,Italy,Korea,Luxembourg,Netherlands,Philippines,Russia,Sweden,Switzerland,Taiwan,Thailand,UnitedStates

Asabove

Asabove

Asabove

ideal results:

Medium

Argentina,Belgium,Brazil,Colombia,France,Netherlands,Japan,Singapore,Sweden

Argentina,Belgium,Brazil,Colombia,France,Netherlands,Japan,Singapore,Sweden

Argentina,Australia,Belgium,China,France,Germany,India,Italy,Korea,Luxembourg,Netherlands,Philippines,Russia,Sweden,Switzerland,Taiwan,Thailand,UnitedStates

Argentina,Australia,Belgium,China,France,Germany,India,Italy,Korea,Luxembourg,Netherlands,Philippines,Russia,Sweden,Switzerland,Taiwan,Thailand,UnitedStates

Argentina,Australia,Belgium,China,France,Germany,India,Italy,Korea,Luxembourg,Netherlands,Philippines,Russia,Sweden,Switzerland,Taiwan,Thailand,UnitedStates

Argentina,Australia,Belgium,China,France,Germany,India,Italy,Korea,Luxembourg,Netherlands,Philippines,Russia,Sweden,Switzerland,Taiwan,Thailand,UnitedStates

[acastelazo · Accepted solution]

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

[BosKev]

Thank you...cool tool.