I work with similar data pulls frequently and am trying to be more efficient in how I transform them.
Typically, I will autofill a field down to the end of the range one column over by using the little black cross displayed when mousing over the active cell:
In this example, I need to fill rows 3 on down by continuing the series in column A. If I use keyboard shortcuts, I can reach the fill (and autofill) dialogue box, but I first have to scroll down to highlight to the bottom of the dates data one column to the right. This can be very tedious in a big data set, because SHFT + DOWN takes me to the bottom of the sheet, not the intended range.
The black cross icon accessed through the mouse understands this logic, but I can't figure out how to reproduce it with shortcuts.
It would be super helpful!