Sorting One Row that Has Multiple Rows Data

Hi, sorry for bothering if this question has been asked. But I didn't know the keyword to search, so I'll ask here hoping for solution.
I have Microsoft Office 2016 and a data like this:
C 1
empty 2
empty 3
B 4
empty 5
empty 6
A 7
empty 8
empty 9

I want to sort it based on first column BUT the data in second column still intact with the first row group:
A 7
empty 8
empty 9
B 4
empty 5
empty 6
C 1
empty 2
empty 3

But a sort function only give a simple sort result. It will sort by treating every row is single row:
A 7
B 4
C 1
empty 2
empty 3
empty 5
empty 6
empty 8
empty 9

Is there any way to sort this kind of data? Thanks.