Fill in Rows with Data in an Existing Field

[crazybeauti_ful]

Hi,

I know multi-row formula tool should work but I tried everything and nothing works. Help please!!

In the sample below, I'd like to replace all non-date values with the date below them so that all values that start with BR should be replaced with 2022-May-01 and all values that start with GB should be replaced with 2022-May-02.

Sample

ID

BR12345

BR23456

BR34567

BR45678

BR56789

2022-May-01

GB98765

GB87654

GB76543

GB65432

GB54321

2022-May-02

Appreciate all the help!

Thank you,

crazybeauti_ful

[Qiu · Accepted solution]

@crazybeauti_ful 
Since the multi-row formula is looking up from top to bottom, therefore we need to do a reverse first with grouping.

[DataNath · Accepted solution]

Hey @crazybeauti_ful really interesting problem - fill down is really straightforward but I've never had to deal with fill up before! The following works for your example. How do you get on applying it to a wider dataset? This also relies on records where there is a date being in the YYYY-Month-DD format, so let me know if that differs!

[crazybeauti_ful]

hi Qiu,

super thank you! appreciate your help!! :)

- crazybeeauti_ful

[crazybeauti_ful]

thank you, DataNath!! amazing to see various solutions to the same problem!

much appreciated!

-- crazybeauti_ful

[Qiu]

@crazybeauti_ful 
Glad to be helpful.