How to make Excel VBA to skip blank cells until a cell has a number

I have attached a spreadsheet and will need help in writing a code that will check the values in Column F and and Col C. The answers to what I need is the in column G (yellow).

Example if col C is 0, it should be blank on G, otherwise if Col C is 1, it should look for the next value in F and return the value , and the rest should be blank. Just like the way I specified it in the spreadsheet.
Any help is appreciated.