ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Splitting a Column of Data into Two Columns of Data (https://www.excelbanter.com/excel-programming/390100-splitting-column-data-into-two-columns-data.html)

[email protected]

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



All times are GMT +1. The time now is 12:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com