<< Click to Display Table of Contents >> Navigation: Reference > Transforms > Fill |
Fill empty cells in selected columns with the next non-empty cell value above/left (depending on direction of fill).
One.
•Check the column(s) you wish to fill.
•Select Direction depending on the direction you wish to fill from.
This is useful for filling in gaps in hierarchical tables. For example filling down the first two columns: