Clarified Post Convert Single Alpha to Side-by-Side (Not Cut n Pas
 

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.

Clarified Post Convert Single Alpha to Side-by-Side (Not Cut n Pas
 

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.

Clarified Post Convert Single Alpha to Side-by-Side (Not Cut n
 

Great! Thank you! Your answer also addressed my next question about adding
new titles and having the columns automatically adjust; and they do. Thanks
again this was more than I expected.

"Bernie Deitrick" wrote:

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.