Alphabetize neighboring column while removing blank cells.

I've got a column "I" where I have pulled all the sheet names in the workbook. I am now trying to alphabetize the results in column "K". I have a formula that works beautifully, but it lists all the blank cells at the bottom of column "I" at the top of column "K". I need either a way to change the formula in column I to retrieve the sheet names in alphabetical order, or have the formula in column "K" sort while removing blanks.

Any help or suggestions would be greatly appreciated.

I've attached a reduced version of the file below.

Here is the formula in column "I":

Formula:

Please Login or Register  to view this content.

Here is the formula in column "K":

Formula:

Please Login or Register  to view this content.

Sort nio blanks.jpg

Is that what you want?

Glad to help, thanks for rep and feedback

If the basic problem is solved
- mark the thread as SOLVED (top right corner over your first post - Thread Tools). This is important for all of us,
Thanks