1 Reply Latest reply: Jan 29, 2014 10:16 PM by Barry
montyfromthe woodlands Level 1 Level 1 (0 points)

I'm trying to convert a row of numbers into a column (aka Excel, paste special transpose).  I'm not having any luck using the Numbers "transpose" function. Suggestions?


iPhone 4S
  • Barry Level 7 Level 7 (29,210 points)

    I'd use a second table with a formula using OFFSET.

     

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

     

    Entered into A1 on the target table and filled into row 1, it will return the values from column A in the source table.

     

    Entered into A1 on the target table and filled into column A it will return the values from row 1 of the source table.

     

    Adjust the $A$1 reference in the Source table to match the top left cell of the range to be transposed. ("Source" in the formula must match the name of the source table.)

     

    Leave the formulas in place for continued transposition of the values or copy the target cells, then Edit > Paste Values (aka Paste Formula Results) if the values are to be moved or remain fixed when values in the target table are to remain constant if the source values later change.

     

    Regards,

    Barry