You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How To Sort Data Keeping Blank Rows In Numbers & Pages Tables

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

Posted on Jul 24, 2021 12:47 PM

Reply
Question marked as Top-ranking reply

Posted on Jul 24, 2021 1:16 PM

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.

2 replies
Question marked as Top-ranking reply

Jul 24, 2021 1:16 PM in response to Jemmma

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.

How To Sort Data Keeping Blank Rows In Numbers & Pages Tables

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.