View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 476
Default 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?