Paste Values copied in alternate rows in a single column

Vikasgohel Posts 2 Registration date Thursday March 16, 2017 Status Member Last seen March 28, 2017 - Mar 28, 2017 at 03:10 AM

I need to paste some data from 1 column to another column but in alternate rows.

for Example:-
Data to be copied is as below.
Cell Value
A1 100
A2 200
A3 Ab200
A4 Cd230

Data required after pasting

Cell Value

D1 100
D2 Blank row
D3 200
D4 Blank row
D5 Ab200
D6 Blank row
D7 Cd230

I am using Win 10 and MS office 365 Pro Plus

Kindly help for the above..