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