View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cshivley cshivley is offline
external usenet poster
 
Posts: 1
Default Seperating data from one column into two columns


I'm not very good at programming. I have one column with values as such:
(x1,y1,x2,y2,x3,y3.......) They alternate from x to y. How can I take
this column and make two columns, one for x and another for y? It is
alot of data, so manual copy and paste is out of the question. Please
help!


--
cshivley
------------------------------------------------------------------------
cshivley's Profile: http://www.excelforum.com/member.php...o&userid=34773
View this thread: http://www.excelforum.com/showthread...hreadid=545344