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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
MacOS Mojave 10.14.6 (18G87)
Numbers version 6.1 (6369)
I have two columns in a table.
I can sort each individual column by clicking on the Column header and choosing Sort in the drop-down menu. That of course changes the other column.
I want to be able to sort both columns, together, in ascending order.
I click on Organise>Show Sort Options.
I add both columns, click on "Sort Now" and nothing happens.
What am I missing here?
MacBook Air
It appears to be sorted correctly now. When you create the sort, it does it as you are creating it. If you later add more items, you can hit "sort now" to re-sort the table. It is sorted first by column B, then by column C.
If, on the other hand, you were expecting columns B and C to be sorted independently, that is not how sorting works in Numbers. Rows stay together just like records in a database. Unless there is something new I am not aware of (and there may be), to sort a column independently you have to drag it out of the table (creating a new table), sort it there, then put it back.
It appears to be sorted correctly now. When you create the sort, it does it as you are creating it. If you later add more items, you can hit "sort now" to re-sort the table. It is sorted first by column B, then by column C.
If, on the other hand, you were expecting columns B and C to be sorted independently, that is not how sorting works in Numbers. Rows stay together just like records in a database. Unless there is something new I am not aware of (and there may be), to sort a column independently you have to drag it out of the table (creating a new table), sort it there, then put it back.
Hi Gordon,
As has already been mentioned above, Numbers tables follow a database model. A sort on any column will sort the rows of the table according to the values in the column being sorted. It will not sort a single column without changing the order of the rest of the columns in that table.
To sort individual columns, you must remove that column (or its data) from the multi column table andplace it in a table of it's own., sort that column, then return the data to the original table.
For your case, using a six (or more column table on which you want columns B and C each sorted in ascending order, with no change in order of the other columns, here are the steps:
The sorted data will be pasted into the column, replacing the original (unsorted) data in that column.
Note: The process takes far less time than writing its description!
Rgards,
Barry
Hi Gordon,
Adding to Badunit's reply, that sort is correct. Column B is sorted first, then rows in Column C are sorted within the already-sorted Column B rows.
If you tell us what is in Column A, perhaps we can help you to use the Categories feature in Numbers 6.1.
Regards,
Ian.
There's nothing in Column A.
What I am trying to do is to sort both columns at the same time, both in ascending order.
Sorting Multiple columns doesn't work
