@temporalnaut
If you want the values in a column adjacent to a populated column that has no blanks, you can enter the starting value in the first cell, then double-click the fill handle in the lower right corner of the cell. Excel will automatically fill the column down to the last used row.
Alternatively, enter the starting value in the first cell. With that cell still selected, scroll down and then hold down Shift while selecting the last cell. On the Home tab of the ribbon, click Fill > Flash Fill.
