Link two or more cells
I’m wondering if I can link two or more cells together so that if I use a filter or if I sort the column they always stay together. And if so, how can I do it?
MacBook Pro 13″, macOS 10.15
Question marked as
Top-ranking reply
Filtering a table does not affect the order of rows in the table, so, provided that the filter does not remove one of the cells and retain the other, the relative position of the two cells wrt each other should not change.
When a table is sorted, the position of each row in the sorted table depends on the values in the cells in the column(s) on which the table is sorted. To keep the two or more cells together, you'll need a 'pre-sort' column with cells containing only two distinct values—one for the cells you want to keep together, the other for the rest.
The pre-sort, on that column will bring the group of cells to the top or the bottom of the table.
A second sort on a different column may change the order of the 'group'and will change the order of the "other group" but will keep both 'groups' together.
The process will work with a hierarchical sort constructed and stored in the Filter inspector.
Done as two consecutive 'manual' sorts, the second sort may sort the whole table, separating the small group.
Regards,
Barry