Fill Row up and down with 2nd Value of another Row

[Rshuddha432]

I have a data table, where I have 2 rows

Now I wanted to create a new field 'New Account' which will only have account Value =A2 filled from top row to bottom row.

[Felipe_Ribeir0]

Hi @Rshuddha432 

If you want to assign the value "A2" for all values of the column New_Account, here it is:

[Rshuddha432]

Values are not Constant for Account, So Filtering option wont work. 

Want to use multi row formula tool. Is there any way?

[Felipe_Ribeir0]

Can you explain with other words what you need to do? Sorry, i think that i did not understand.

Your example output has the value A2 fixed for the New_Account column.