How can I resort data form alternating Rows???

  • Thread starter Thread starter mike schmidt
  • Start date Start date
M

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!!
 
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.
 
thanks
Dave Peterson said:
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.
Click to expand...
 
Back
Top