What is advance sorting?
The advanced sorting function is used to apply sorts on multiple columns in a report. It enables the report author to specify the column order and sort direction that they desire the report to be sorted by.
How to do advanced sorting in Google Sheets?
Advanced range sorting options.
If your columns have titles, click Data has header row. Select the column you'd like to be sorted first and choose a sorting order. To add another sorting rule, click Add another sort column.