Excel expert needed

[Goldy]

Hi,

I have 2 columns of numbers in Excel, Column A and B. Each column has 50 values. What I want to do move Column B into Column A so that the each odd row is the value from column B, thereby making a column with 100 values in it.

Or even if I can somehow add an empty row between every other row that would be a good start!

Any ideas how I can do this?

 

[Goldy]

Thanks wonko, that'll do.