Ask Your Question

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?

asked 2020-10-05 12:39:08 +0100

appreciatethehelp gravatar image

updated 2020-10-05 15:43:32 +0100

OS Mojave 10.14.6, LO

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.

edit retag flag offensive close merge delete


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 gravatar imageLupp ( 2020-10-05 15:40:06 +0100 )edit

@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.

LeroyG gravatar imageLeroyG ( 2020-10-08 21:45:47 +0100 )edit

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. .

Lupp gravatar imageLupp ( 2020-10-08 22:52:10 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-10-05 16:09:07 +0100

Lupp gravatar image

updated 2020-10-05 16:11:44 +0100

The problem as seen by the questioner will not have a solution of the expected kind (by a built-in tool of Calc).


Assuming the sheet intended to keep data, and to allow for their editing, mainenance, completion...
-1- Spreadsheets aren't databases.
-2- If used for similar purposes nontheless, they should, however, obey the most basic DB rules.
-3- There are the so-called Normalizations e.g, in specific up to N3.
-4- Normalization may not be the main concern in this case.


-5- Don't tamper with the original data, except for urgent maintenance (corrections) and completion.
-6- Any direct manipulation (except mandatory correction or deletion) must be reversible.
-7- Sorting shouldn't be done for the data themselves, but only for reports created from them.
-7a- If original data are sorted nonetheless, all fields (columns) must be included.
-7b- The autofilter context isn't usable insofar.
-8- The concern of the question should be to find a design of the sheet supporting the intended proceeding.
-9- Empty cells in a field (column) are only acceptable where the being empty is an information in itself.
-10- "Group continues" is not such an information (probably except if the relative position is unchangeable).
-11- The mentioned information should (must) be given by repeating the group ID.

See attachment.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-10-05 12:39:08 +0100

Seen: 37 times

Last updated: Oct 05 '20