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

  • Thread starter Thread starter Lin400
  • Start date Start date
L

Lin400

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.
 
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
 
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.
 
Back
Top