Using CALC: I have opened a CSV file table with about 3000 lines and 8 columns. It is a list of all the SNAP accepting stores in Colorado. It is not alphabetized in any column. I want to be able to view all the stores in my county or city (two of the columns) without reading through the entire 3000 lines. Alphabetizing by column data would help immensely. There is no obvious way to alphabetize the table by the data in any column.
Were I to have my “perfect solution”, I would click on a column to select it, then click again to alphabetize “up” and click a 3rd time to alphabetize “down”, just as we can do with most PC window contents by column. Failing that idea, I’d right click any column to find the option to alphabetize the entire table by the contents of the selected column. Why is there no such ability???
2nd option to go with this would be to save the table “as last viewed” (and other possibilities).
3rd option would be to renumber the table as re-ordered by alphabetizing (and other possibilities).