Fill empty cells with previous/next value
Fill empty cells in column(s) with the previous or next non-empty value.
Example
Values |
Fill with previous |
Fill with next |
---|---|---|
A |
A |
A |
A |
B |
|
B |
B |
B |
B |
Options
When filling with previous value, you can specify multiple columns. When filling with next value, you can use only a single column.