This should be a very simple task, but I can't seem to make it do it. All I need to do is arrange a set of values from smallest to largest. I set up an experiment table with three columns and ten rows, each containing the numbers 1 through 10 in random order. I bring up the reorganize window and tell it to sort like this
As you can see, only the selected column is sorted. So I tried this to apply the sort to all three
And here is the problem. I cannot get it to sort all the data in numerical order. I have a much larger table that needs a whole bunch of masses sorted like this, and when I try it on that spreadsheet all the numbers get disorganized. Gaps and empty cells come up inbetween some of the filled cells and only one column ends up getting sorted. It also moves my standard deviation, number of samples and average rows into the group even though they weren't selected to be part of that sort.
We had to mass pennies from a bunch of different years to "learn" how do do statistical math stuff so we can apply it to analytical chemistry. In the big table each column has the year at the top then all the masses under it. If each row had the year and then all the masses from that year to the right of it would this work? Then it would sort from smallest being on the right to largest on the left?
Sparknotes: In the program numbers, I need to sort values under each column smallest to largest order. I can't get the computer to do it without moving all my other values and only sorting one column. Halp! This has been preventing my progress all day.