Rex,

This is easy to do in Excel by using the paste special command and choosing the Transpose option.

Unfortunately, I don't think this functionality is currently available in Numbers. The easiest method would probably be to move the values manually.

If you have a large number of rows to transpose, it may be possible to write a formula to automate the process.

Michael

If you havea range from B2:D2 that has your values and I want to transpose them going down starting in cell B4. I could use this formula then copy it down:

=INDEX($B$2:$D$2,1,(ROW()-3))

Index returns the item in a certain position in a range. The second argument is the row to look on, which will always be 1 for our range. The third argument is the column to look in. Since I want the item in row 4 to look at the item in column 1 of my range, I can use Row()-3 to get my number 1. Fill down and the next row down will look in the second column. etc...

Hope this helps, Jason

p.s. you can also download an applescript to do the same thing, but I am not quite there with applescipting.

Like most things, it's easy when you know how. However, it's certainly not as straightforward as Excel's "Paste Special - Transpose". Here's an extract from an e-mail I sent to my father explaining what he needed to do. It's not particularly well explained, but if you copy & paste the formula & then play about with it, it should start to make sense.

"Unfortunately, this is one of the areas where Numbers '09 still lags behind the other spreadsheets. The answer wasn't particularly straightforward to find or follow. However, this is the formula you need that will work with autofill/drag-fill (ie it only needs to be entered once & can then be dragged to fill the desired area).

=INDEX(TRANSPOSE($A$1:$C$4),ROW()+1-ROW($A$20),COLUMN()+1-COLUMN($A$20))

This example would be used to transpose a 3x3 selection (A1:C4) & relocate it starting at A20. This formula would be entered in cell A20 & then drag-filled to the appropriate size (in this case 3x3). To make use of it, replace "$A$20" with the location of the cell you are pasting the formula into & replace "$A$1:$C$4" with the data you want to transpose (highlight "$A$1:$C$4" in the formula & then drag over your data to replace)."

Please note that the empty brackets are supposed to be empty. Also, this was for a square selection (3x3), but will work for any rectangle (eg 3x7 to 7x3).