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?

 

[wonko]

The first thing that comes to mind is to create extra columns to the left of columns A and B and put values in to use for sorting. I.e. 2,4,6,... in the one to the left of the original column A, and 1,3,5,7... to the left of the original column B (use formula then paste values). Then move the new column B data under the column A data and sort.
Hope that makes sense!

 

[Goldy]

Thanks wonko, that'll do.

 

[wonko]

You're welcome - glad you got it sorted.