Is it possible to keep blank rows beneath each subject row while using sort option?
Currently using table in pages. When sorting - the sort pushes blank rows out.
Is there an option to keep blank rows in place when sorting ?
Thank you for your time.
iMac 27″ 5K, macOS 11.4
The collating sequence for a Pages ascending column sort, where there are blank rows, will move blank rows to the end of that column, unless that is their original location:
Original:
Sorted:
But when:
sorted, it becomes:
This is how Pages has implemented the table sort facility and spaces have lower sort values than numbers and letters. In LibreOffice Writer v7.1.4, a table column like the following when sorted alphanumerically:
becomes:
Blank rows are not your friend in table sorts, and there is no setting to lock specific rows and make them invisible to sort operations.
The collating sequence for a Pages ascending column sort, where there are blank rows, will move blank rows to the end of that column, unless that is their original location:
Original:
Sorted:
But when:
sorted, it becomes:
This is how Pages has implemented the table sort facility and spaces have lower sort values than numbers and letters. In LibreOffice Writer v7.1.4, a table column like the following when sorted alphanumerically:
becomes:
Blank rows are not your friend in table sorts, and there is no setting to lock specific rows and make them invisible to sort operations.
You might work around this by sorting the column without blank rows, and then adding blank rows back where you need them unless there will be subsequent sorting need.
How To Sort Data Keeping Blank Rows In Numbers & Pages Tables
