Splitting a Column of Data into Two Columns of Data

B

blee2879

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple example of a range argument to a UDF? 6
Help with creating drop down 1
How do I set the source data to make this graph? 0
Sort coordenates independently 0
Calulating a point on a line 2
One Entry to Multiple Rows 1
MS Office Outlook 2003 & MS Excell 2003 0
Seperating data from one column into two columns 2

Top