In column A, include all your alphabetized titles, starting in A2.

Then use this formula in, say, cell B2

=INDEX(A:A,ROW(A1)*2)

And this in C2

=INDEX(A:A,ROW(A1)*2+1)

and copy down.

That way, when you add a title, you can sort column A only, and your list will update.

HTH,
Bernie
MS Excel MVP


"Lin400" wrote in message
...
I phrased this badly before. I have a long list of alpha DVD titles in two
columns. I have illustration #1 but I want #2. Thanks!

#! #2
a e a b
b f c d
c g e f
d h g h

I want to be able to read the titles from left to right alphabetically, NOT
up and down again like a book or newspaper column.