View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] blee2879@gmail.com is offline
external usenet poster
 
Posts: 1
Default Splitting a Column of Data into Two Columns of Data

I currently have an M$ Excel file with data that looks something like
this:

Cell 1 Cell 2 .... Cell m
-----------------------------------
x1
x2
:
xn
y1
y2
:
yn

I'd like to get the format into:

Cell 1 Cell 2 .... Cell m
----------------------------------
x1 y1
x2 y2
: :
xn yn

Where the x and the y are next to each other and in different columns,
for 'm' cells.

Can someone help me out with a macro? Thanks!

blee2879