How to duplicate the row

[Skyong1976]

Example
Money row 1

Coin row 4

Is there any way to repeat row 2 n 3 as money and 5 n 6 as coin as I have hundreds line to do. Thanks

[#2]

@Skyong1976 

To do so, follow these steps...

1. Select all the cells in column A with data and including blank cells.
2. Press Ctrl+G to open Go To window and click on Special and choose Blank radio button.
3. The above step would select all the blank cells in column A in the selected range.
4. Now, type = from your keyboard and press UP Arrow key and press Ctrl+Enter.
5. Then select the whole range again, copy it and paste it back as Values only.