Fill down Latest Non-Null Value in a Column

[hemant86]

Hi All,

I have data in below format -

I need to fill down latest non-null value. So the expected output is below

I am able to achieve this using Multi-Row tool but it works only for 1 Field at a time and I have more than 30 fields to fill. Any way to use Multi-Field tool and achieve the same.

[hemant86]

@DataNath The workflow that you shared works for the sample data I shared earlier. Even in case of of Columns having all Null values. Problem is with this dataset that i just shared

[DataNath]

@hemant86 understood. Are you able to check this over? I think the groupings should work but hard to tell without a more extensive dataset.

[hemant86]

Hi @DataNath Can you please try the attached file. This very close to what my data set looks like. The above flow works fine for a single column but fails for multiple columns.

[DataNath · Accepted solution]

@hemant86 most recent iteration:

[hemant86]

Thanks a tone @DataNath This did the job for me.😊