Atleryx - use regex or formula tool to change row #n to match first row

[dataviolet]

Hello,

I have data that looks like this:

Column1

Entity 1

Entity 2

Entity 3

Entity 4

Entity 5

Entity 6

Entity 7

Entity 8

Entity 9

Entity 10

.....

Entity Cons

I want to create a formula to change "Entity Cons" to be whatever the first row of data says. In the case above, I want "Entity Cons" to say "Entity 1." 

How can I go about doing this? I was thinking maybe a multi-row formula with an IIF(contains([column1],"cons"....

but I'm not sure how to get Alteryx to spit out the first record. I simplified the data here, the real data doesn't actually contain numbers 1-10, so I'm not sure how to get this formula to work.

[Qiu · Accepted solution]

@dataviolet 
Something like this?

[dataviolet]

thank you, yes this works! thanks for helping me think of my data in a different way.

[Qiu]

@dataviolet 
Glad it helps and thank you for mark it as accept.