Using the Fill Down feature
Using the Fill Down Feature
By Dan Howell June 14, 2017
Use fill down to populate blank cells with data from the cell above. The fill down continues for blank cells until the next populated cell is encountered in the column. This feature is commonly used with data that has header rows in the data (as shown in the example below), but is also applicable in other scenarios.
In our example, assume you have a dataset that has certain information on header rows – indicated with a Record Type Code of “1”, and other rows with detail and subtotal information – Record Types 5 thru 9.
The objective is to populate all the cells with the correct information.
The steps to populate blank cells with data from the cell above:
- Expand the column-level gesture menu.
- Click on Fill Down
A teal-colored preview menu will show you what the result will look like:
- Do the same for all other columns you need to fill down until the objective is met
- Note: In some cases, you may need to sort the column to fill all the cells correctly.
Notice that in the image below, the first cell is empty.
- By clicking on the column header “Effective Entry Date”, a sort will be applied to the step.
n.b. you don’t have to sort on the same column you are Filling Down; you can sort on any, and multiple, columns.
Once the header information has been pushed down to other rows, it is likely that all header rows would then be removed.