Replace Null by value of the same column?

Question

Hello

I am comparing previous quarter data to current quarter data and I have a column called [Current Quarter Year]".

In some cases the cells are empty as there are no entries for current quarter anymore.

however I want to show comparison by creating a workbook name:  + [Previous Quarter Year] + " to " +[Current Quarter Year] + " Movements.xlsx" + "|||Mov

Due to the missing quarter I am getting two files as output

2021 Q4 to 2022 Q1 Movements

2021 Q4 to Movements

How can I replace the empty [Current Quarter Year]  record lines with the related current quarter entry to receive just one output?

Input                         Output

2022 Q1                    2022 Q1

[NULL]                      2022 Q1

Any idea? Thank you in advance.

DataNath · Accepted Answer

There's a few options here @horth007:

If you don't mind updating the workbook manually, you can simply use a formula with the value you want to fill nulls with -

If your first row will always contain a value, then you can use a Multi-Row formula with the following configuration to simply fill down -

If you don't want to monitor this, you can just take the max value (i.e. anything non-null) from a Summarize tool, append it to your data and use it to fill the gaps -