Manipulating a column array into different cell locations
I have a long list of 400 names in a column array A1:A400
I want to "double space" this data.
That is, introduce a blank row after each name in the column in order to get
a new
array that now contains the same data spaced out in B1 B3 B5 ....etc....B800
Is there an easy way to do it without dragging and dropping 400 times?
|