Fill Repeating Data
The Fill Repeating Data can be used on a range that has gaps in the content. Given a range like this:
![non-repeating-data](/images/non-repeating-data.png)
Filling in the missing data will result in this:
![repeating-data](/images/repeating-data.png)
Form Fields
- Range: Select the range to fill-in the repeating data. (This field is preset with the selected range when the form is opened.)
- Direction: Set the direction based on whether the repeated data is in columns or rows.
- Save workbook: See Close and Re-Open Workbook for details.
Related