Fill down value

[tiverson]

I have data that has an account number assigned to the first row of data for each date.

I want to assign the account number to all of the rows.

Data

Desired Output

[IraWatt · Accepted solution]

Hey @tiverson,

You can achieve this with a multi-row formula like so (workflow attached):

If you have any questions on how this works make sure to ask :) 

HTH,

Ira

[tiverson]

@IraWatt, thanks for your help!

[IraWatt]

No worries glad it worked !