Replace specific text with specific text in the row above

[D_Y]

I have text that looks like this

Field Name

Alpha Additions

Field_1_1 Upgrades

Field_1_2 Subtractions

Bravo Additions

Field_1_3 Upgrades

Field_1_4 Subtractions

I am trying to cleanse the text so that it looks like this

Field Name

Alpha Additions

Alpha Upgrades

Alpha Subtractions

Bravo Additions

Bravo Upgrades

Bravo Subtractions

I know this likely involves the Multi-Row Formula with maybe a Parse or Regex formula, but was unable to combine all this together to get it to work.

Any help would be appreciated!

[binuacs · Accepted solution]

@D_Y One way of doing this with the Multi-Row formula tool

[Deano478]

Hey @D_Y  this is a longer way but you can achieve the result

[D_Y]

Thank you!

[D_Y]

 Thanks as well!