Using one row, how do I fill the row below (numerous times)?

[Guest]

I have a workbook. It has numerous rows. some of the rows are a master
identifier for rows below it. The cells below the 'master row' are empty. How
do I copy the 'master row' to 'fill' the cells for the subordinate rows
beneath it. i.e.

| 1 | abcdef | hhhhh | | |
| 2 | | | jjjjj | ppppp |
| 3 | | | kkkkk | yyyyy |

Using the above, how do I copy the cell contents from cells in row 1 to the
empty cells beneath them in rows 2 and 3? I know an easy copy and paste would
work. However; my spreadsheet has 500+ rows with multiple 'master rows'.

I attempted to use a macro; however, it copied/pasted to the same cells,
over and over.

Please help. Thanks.

 

[Guest]

My usual approach is based around data filters. Turn on the autofilter (data
/ filter / autofilter). Then use the drop-down in column A and select
"(blanks)". In the first blank cell, enter an equation to pull in the value
from the cell above (ex, if it's row 5, enter =a4). Then copy that formula
down through all the visible rows via a simple autofill. Use the drop-down
to Select All.
Repeat for subsequent columns.
--Bruce

 

[Ragdyer]

Try this:

Select your range,
Hit <F5>,
Click "Special",
Click "Blanks",
Then <OK>
Type the equal ( = ) sign,
Hit the <UP> arrow,
Hit <Ctrl> <Enter>.