trying to reduce complication.

you can do exactly what you were doing.
filter column F for blanks.
then use formula: in F3 type "=G3"
copy this cell and paste down. (because u are copying only one cell- formula will be pasted only on filtered cells)

After you are done, if you don't want formula to remain in Column F. Remember to copy full column and 'paste values'