Fill in Rows with Data in an Existing Field

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

BR12345

BR23456

BR34567

BR45678

BR56789

2022-May-01

GB98765

GB87654

GB76543

GB65432

GB54321

2022-May-02

Appreciate all the help!

Thank you,

crazybeauti_ful

Tips and Tricks

Best Practices

Accepted answers

Qiu

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

0713-crazybeauti_ful.yxmd

DataNath

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!