Relative cell references not updating for both columns, only one

by Rubin|Published March 11, 2025

I was expecting all cells to contain rows from F column, in incrementing value (ie. F2, f3..f5,f6). I have tried absolute references, dragging down three manually inputted and correct rows to make it autofill the correct structure but it didnt work.