LastNonEmpty Function

With this function, empty column values are replaced by the last column value of preceding rows that are not empty, which means that the value from the last time that was not empty is repeated.

Parameters

EmptyValue The value that is considered as an empty value. By default, empty spaces consist of space, multiple spaces, blank, or null values. For example, value “0” can be replaced with last none “0” value. In most cases, this parameter can be omitted.
Default If all preceding rows have an empty value, the default value is returned.

Updated December 9, 2024