Excel Macro code to move data from one line on a sheet to multiple lines on another sheet

Greetings Excel Experts,

I have a macro that is successfully copying the data I want from one sheet to the next but now I need it to work a little harder and copy more data from the same line to subsequent lines in the sheet.

I am attaching a simple example of the kind of logic I need help with. If there is no data (blank or null) in the Grant field the data is not printed. In other words there can be no blank lines.

Please let me know if you need more information. I truly appreciate the help as I am stuck on this right now.

Thanks!

There is no macro on the attached sheet