Sort Part of a List

I am an advanced user, so don't baby it for me. Maybe I'm just brain farting, but I can't seem to do this with the GUI. I could program some lengthy array sorting and re-organizing to do it, but there has to be another way.

Quick version of problem: Given a table of 100 rows, only select 10 rows and sort those 10 alphabetically while leaving the other 90 exactly where/as they are.

Detailed Issue:


C1 - C2
aa - bc
ab - bb
ac - bd
ad -
ae - bb
af -
ag - bb


I have the above two columns. Column 1 has names in alphabetical order, and column 2 has an identifier or Nothing. Very basic. I want the outcome to be the following:


C1 - C2
aa - bc
ab - bb
ac - bd
ae - bb
ag - bb
ad -
af -


I want column 1 sorted alphabetically grouped with column 2 data, so the top half of the table has alphabetical (A-Z) with data in column 2, then the bottom half has alphabetical (A-Z again) data with no data in column 2. With my logic, I should be able to sort Column 2, which temporarily makes it alphabetical and ignores column 1.... then I select ONLY the data in Column 1 from row 1 to row countCol2Rows, and sort that selection alphabetically. However... when I sort just that selection alphabetically, the entire "active range" is sorted. It should all be one table, I can't make this two tables.

This was certainly important to take care of, and I'd love to solve it. Also, thanks for the help. But I just copy pasted the data and re-formatted it seemingly EXACTLY the same, and the issue didn't follow the worksheet. Same book and everything.

To sum up, when trying to sort any part of the table, the entire table would auto-select and any sorting done to any column would apply to the whole table. To make my sort work, I had to sort by column B, then sort part of the results by column A. Not sure what was locking it into auto-expand to the whole area, but a new sheet fixed that. If anybody has an idea it would be great for the future, but for now a new sheet works.