Row Fills

[upcea]

I have a fairly large spreadsheet and many of my rows are blank. What I would like to do is fill the blank rows with the data from the rows above. For example:
Row 1 has data in columns A-AT
Row 2 EMPTY/BLANK (I would like this Row to have the same data from Row 1)
Row 3 EMPTY/BLANK (I would like this Row to have the same data from Row 1)
Row 4 has data in columns A-AT
Row 5 EMPTY/BLANK (I would like this Row to have the same data from Row 4)
Row 6 EMPTY/BLANK (I would like this Row to have the same data from Row 4)
Row 7 EMPTY/BLANK (I would like this Row to have the same data from Row 4)
Row 8 EMPTY/BLANK (I would like this Row to have the same data from Row 4)
Row 9 EMPTY/BLANK (I would like this Row to have the same data from Row 4)
Row 10 has data in columns A-AT
Row 11 has data in columns A-AT
Row 12 has data in columns A-AT
Row 13 EMPTY/BLANK (I would like this Row to have the same data from Row 12)
Row 14 EMPTY/BLANK (I would like this Row to have the same data from Row 12)

Does this make sense? Can anyone help?

 

[VoG]

Select all of the data, press F5, click Special, tick Blanks and click OK.

Press =

Press Up arrow

Hold down CTRL and press Enter.