A sortable list of groups, or having multiple types of data on the same column

Sorry if the title’s vague, but I don’t know if there’s a word for the type of thing I’m trying to create. Allow me to illustrate with a picture:

Is it possible to create a spreadsheet consisting of groups of rows containing several different types of data, and be able to sort those groups according to any of the data within them without rearranging the contents of the groups themselves?

Merged cells will prevent you from sorting.

Tested with LibreOffice 6.4.7.2 (x86); OS: Windows 6.1.


Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.

Check the mark (Answer markCorrect answer mark) to the left of the answer that solves your question.

If the answer helped you, you can mark the up arrow (Upvote mark) that is on the left (to vote, you need to have karma of at least 5).