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.
Bookmarks