How can I resort data form alternating Rows???

[mike schmidt]

My data is as such in a column
ax
34
dc
45
tt
12

How can I take data such as above and convert it to-

ax 34
dc 45
tt 12

I need to take data in alternating rows and put the "odd" data in one column
and the "even" data in the adjacent?

Thanks for any help!!

 

[Dave Peterson]

One way:
Put this in B1
=INDEX(A:A,(ROW()-1)*2+1,1)
put this in C1
=INDEX(A:A,(ROW()-1)*2+2,1)

Drag both down until you run out of data.

Select columns B and C and edit|copy, Edit|paste special|Values
delete column A.

 

[mike schmidt]

thanks

One way:
Put this in B1
=INDEX(A:A,(ROW()-1)*2+1,1)
put this in C1
=INDEX(A:A,(ROW()-1)*2+2,1)

Drag both down until you run out of data.

Select columns B and C and edit|copy, Edit|paste special|Values
delete column A.

 

[Alan Beban]

For those who have available to their workbooks the functions from the
downloadable file at http://home.pacbell.net/beban

=ArrayReshape(a1:a6,3,2)

array entered into a 3-row, 2-column range.

Alan Beban

thanks