I'm using the Filter (the one you create with the button in 'menus') to sort my table, but when I click the filter icon in a column's header and select "Sort A→Z", it only applies to that column.
Current behavior: As you can see, Column 1 is sorted from A→Z, while column 2 goes "ABACA" - it's not being sorted.
Intended behavior: Column 1 is sorted from A→Z, while columns 2-6 are also sorted from A→Z. Basically, can I sort all of these columns from A→Z, with an interactable header button like the filter one? I'm pretty sure Excel can do something similar (while also letting you sort the individual columns), although I've never used the program.