Multi-Row Formula Tool with random null value

Hi all, I'm looking for a solution for this situation: a column where the correct value is present but in a totally random position like this example

Date or it could be Date

Null Null

Null Q4 2020

Q4 2020 Null

Null Null

Null Q4 2020

Null

Q4 2020

The desired output should be:

Date

Q4 2020

If I use iif(isnull([Date]),[Row-1:Date],[Date]) it works except for first record that remains blank

Developer

Accepted answers

If there is always only one distinct value per column, you may use this flow:

This can be easily done by filtering non null quarter groupby to get a single value. Then add it back a column to main data.

Edit : Similar to @Drussek approach.

Hope this helps 🙂

I've attached a tool that autofills the value down for you.

Hope this helps,

Is the value same for all rows or do they change. If yes can you provide more example.

If there is always only one distinct value per column, you may use this flow: