Hi "Lin400"

With your data in Col A starting from Row 1; try the below formula in B1, C1
and the cells below as required .

=INDEX($A:$A,(ROW()-ROW($A$1))*2+COLUMN()-1)

If this post helps click Yes
---------------
Jacob Skaria


"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