Convert Single ALPHA Column to Two
On Sat, 13 Jun 2009 12:04:01 -0700, Lin400
wrote:
I have almost 800 rows of alpha titles in one column I want to split into two
columns, while keeping them in alphabetical order - side-by-side rather than
one long alpha list.
Is this poss without spending hours moving each line manually?
V. Excel 2003
If your data are in cells A1:A800, try this:
In cell B1 you enter the following
=OFFSET(A1,2*ROW()-2,0)
In cell C1 you enter the following
=OFFSET(A1,2*ROW()-1,0)
Then copy cells B1:C1 down as long as needed (to B400:C400 if you have
800 data)
Finally copy cells B1:C400 and paste them with
"Paste Special / Values" to where you want your two new columns to be.
Hope this helps / Lars-Åke
|