here's how to transpose rows to columns

Hi Hershel,

While that is, as described, a 'simple' method to transpose, it's not the only one, nor is it the easiest to set up.

Numbers will auto-adjust the row reference(s) of a formula when filling down, or the column reference(s) when filling right. Unfortunately, the method described in the linked post requires adjusting the column reference of a formula as it is entered down a column. That must be done manually.

Here's a method that uses a longer formula, and a second table, but has the advantage that the formula needs to be entered only once; after that it's simply Filled Down and Filled right to place the adjusted formula in all of the other cells.

Table 1 is the original table. Table 2 needs to have as many rows as table one has columns, and as many columns as Table 1 has rows. The limit on both of these is 255, the maximum number of columns in a Numbers table. (The example uses 10x10 tables to ft easily into a page in this discussion.)

Formula (in A1 of Transposed. Copied of Filed from there to all other cells on the Transposed table.)

=OFFSET(Original :: $A$1,COLUMN()-1,ROW()-1)

Regards,

Barry