Fill down value

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

Accepted answers

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

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

@IraWatt, thanks for your help!