Numbers

You can transpose a table by clicking in it and in your menu choosing Table > Transpose Rows and Columns.

If you want to choose just one column to transpose you can select that column and either option-drag (to copy) or drag (to move) to the canvas, where it automatically forms a new table. Then transpose that table via Table > Transpose Rows and Columns.

SG

It turns out (I just tried; this may be new as I don't remember coming across it before) that you can do similar in iOS! Select the row (or column), drag to the canvas, tap the new one-column or one-row table then Table Actions... Transpose Rows and Columns, then copy-paste or drag into position in the destination table.

SG

Hi Treeman,

Read the rest of SG's comment:

"If you want to choose just one column to transpose you can select that column and either option-drag (to copy) or drag (to move) to the canvas, where it automatically forms a new table. Then transpose that table via Table > Transpose Rows and Columns.

SG"

You can do that for rows!

quinn

Treeman47905 wrote:

I saw this option, but I don't want to transpose the entire table. I just want to take a row of numbers and paste into a column in another table.

Select the cells in the row (or column).

Drag (move) or Option-drag (copy) the selected row to the canvas, forming a new table

In the new table Table > Transpose Rows and Columns, giving you this:

Select, copy, and paste into another table. (Or just drag to where you want the values in the other table.)

Done in under a minute! No formulas. No fuss.

Works when you copy a column and transpose that into a row too.

SG

You can use the TRANSPOSE function for this. See example below.

In my example, I want to transpose the array Column::B2:B7 into Row::C2:H2. The formula I write into C2 is shown above. Simply fill this formula across to H2 and you’re done.

SGIII’s method is the simplest, and thus advisable solution to use for macOS. My solution becomes necessary however if using Numbers on iOS, so I submitted it for the benefit of future readers to this thread. The original poster will want to use SGIII’s solution.

Indeed you are right. Learn something new every day.