Paste Values copied in alternate rows in a single column [Closed]

Report
Posts
2
Registration date
Thursday March 16, 2017
Status
Member
Last seen
March 28, 2017
-
Hello,

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..
Thanks
Vikas@removed by moderator.com