Transpose and Alphabatize

[joedrummer]

I have dynamic titles in row A, listed in no order and with blank cells between all the titles. On another sheet I want the titles listed in column 1, alphabetically and without gaps.

I have gotten very close by using the COUNTIF function, but have had trouble looking up the results. Sorry if this is confusing, and thank you in advance.

-Joe

[NBVC]

Please Login or Register  to view this content.

adjust sheet name and ranges to suit..

then confirmed with CTRL+SHIFT+ENTER instead of just ENTER and copy down.

Depending on your range size, this could be quite slow...

you can split the formula and use a helper column...

I.e. in the original sheet add formula next to column A...

Please Login or Register  to view this content.

order.

then in sheet2, use formula:

Please Login or Register  to view this content.

which is to be confirmed with CTRL+SHIFT+ENTER after adjusting sheet name and ranges...then copied down.

Attached workbook shows both methods.
.
.

[joedrummer]

Thanks for your help, my problem if fixed!