Autofilter (preferably, or filter via another method) to alphabetise entries in column 1, whilst still preserving empty rows between cells containing entries in column 1, and alphabetising entries in column 2 (adjacent column) in groups from one cell adjacent to an entry in column 1 to the next?
OS Mojave 10.14.6, LO 6.2.5.2
Please pardon the rather convoluted question; it's a rather difficult one to convey succinctly!
I want to filter (using autofilter preferably) entries in a spreadsheet whilst preserving the preexisting empty cell spaces between each entry in one column (we'll call it "column 1" for reference), and alphabeticising the entries in groups in the next column (column 2) from one entry adjacent to an entry in column 1 to the next.
As it is a little hard to explain in words, I have attached an example of the result I'm currently getting using autofilter, and how it differs from what I'm trying to achieve:
C:\fakepath\Autofilter Example.ods
As always, my gratitude.
As far as I remember, you already got an answer which pointed out that
-1- Filtering is completely different from sorting.
-2- The shortcut commands concerning sorting offered by the popup of AutoFilters should be deprecated
-2a- because they mainly are efficient with causing misunderstandings like the current one,
-2b- because they also are of little use due to not being extensible to additional columns.
Where did that answer go?
Since then the question's summary remained much too long, and the editing didn't actually make things clearer.
Please edit the question another time trying to actually center on what you need/want.
I will meamwhile try an answer emphasizing the impact of "...whilst preserving the preexisting empty cell spaces between each entry in one column...".
@Lupp, Would you help me with a small favor? I am collecting data about how many karma is needed for which activities in this site. Could you hover the mouse pointer over the karma points (next to your user name at the top) and share here the content it display? It will say "Currently, you can:…". Once copied I'll delete it. Thanks in advance.
I never knew... The information shouldn't be secret, but I only know a very old table listing the empowerments associated with up to 500 points.
Anyway I'm not sure if the threshold there were changed , and I never knew additional thresholds.
The list you mentioned doesn't contain them, and it doesn't seem to be sorted by thresholds.
I will probably come back to your question, but now I want to sign out, and tomorrow i will be off most time. .