Currently Being ModeratedFeb 10, 2013 3:33 PM (in response to pinsandneedles)
Pages can't sort one column independent of the others, and neither can Numbers. One solution is to Copy the Column, Paste it to a blank area away from the original table, or in a new document, Sort the severed column/table, Copy it, then Paste it back to the original location. This only works with literals and constants, not with formulas.
Another approach is to not put unrelated data sets into the same table, but rather use a separate table for the data that needs to be sorted independently.
Currently Being ModeratedFeb 10, 2013 4:23 PM (in response to Jerrold Green1)
Jerrold I think you can sort a column or row independently in Numbers.
The only thing is that spreadsheets consist of related data, I can't think when you would want to rearrange one row or column but not its associated row or columns.
Currently Being ModeratedFeb 10, 2013 5:13 PM (in response to PeterBreis0807)
Numbers sorts full rows on values in selected column(s). The technique for sorting a single column is essentially the same as Jerry is describing for Pages tables—separate the (data in the) column to be sorted, sort it, return it to the table.
In Numbers the actual column may be separated from the original table, sorted, then returned. In Pages, the data must be extracted, sorted, then pasted back in, overwriting the unsorted data (if it was left in the original table).
iWork tables follow a database model in which each row is a Record, and each column holds a Field within the records.
As evidenced by the current question (and several similar questions arising in the Numbers community) that model doesn't apply to the way some users, especially some who come in from the MS Excel world, use tables.
With Excels model—islands of data on a single large table, the ability to sort one or a selected few columns of data makes sense. One 'island' may comprise only cells AA21:AH50. Sorting that small 'table' should be possible without disturbing the rest of rows 21-30, which are probably part of one or more other 'data islands' in the sea that is a MS Excel spreadsheet.
In Numbers, each of those 'islands' would be a separate Table, and that Table would be sortable without disturbing other Tables in the document.
Currently Being ModeratedFeb 11, 2013 4:22 PM (in response to pinsandneedles)
I know I could sort in Numbers, but I wanted to know if I could do the same in i Works. your explanation is satisfactory. I will use Numbers. I think what I could have done and I have not tried it is to create a Table using only one column, the sort it and then create another table of one columnn and sort it, but that is a lot of extra moves, when numbers is easier. Thanks again.
Currently Being ModeratedFeb 11, 2013 4:27 PM (in response to pinsandneedles)
Please come back after trying this in Numbers and tell us how it went.
Wishing you luck,