Hi everyone. could anyone help on a sorting problem.
I am working on an excel sheet like the first attachment, I want to sort by "Team". But is it possible to keep the headings (the first 3 rows) and those titles and sub-titles (e.g (A) Transportation and i) Public Transport...) when I do the sorting (also with the blank row in between different categories (e.g. the blank row between part (A) & part (B)) ? The second attachment is the result I want to have.
I have tried different ways but still could not get it right. Could anyone helps? Thank you all so much in advance!!!
Before sorting:
擷取excel.JPG
After sorting:
擷取excel1.JPG
Bookmarks