Transposing data in Numbers

chrell01 wrote:

I know I can transpose a whole table but what if I want to transpose a particular subset of cells. I don't seem to be able to just highlight the cells/rows/columns and transpose them only.

Just select the range of cells you want to transpose, and drag them onto the canvas. They will automatically form a new table. Transpose that table. Then select its cells and drag them back into the original table.

You can sort rows but not columns. Normally you would want dates going down a column.

SG

Transpose returns an array. Only one value can be shown per cell, of course, but you can read the array with the Index function like this:

Note that I am keeping the cell reference, and for a column reference I am using the column function, which returns the column number of the present cell. So this is the only reference in the formula that will change. When I fill across...

With regards to your second question, columns can be used as categories, but not sorted. Only rows can.