2 Replies Latest reply: Aug 29, 2013 6:43 PM by Wayne Contello
demberapple Level 1 Level 1 (0 points)

Is it possible to reverse the columns and rows in a Numbers SS so that the information that goes across the page in columns, goes down the page in rows, and vice-versa?


Numbers, Mac OS X (10.7.5)
  • fireflyer Level 2 Level 2 (310 points)

    Take a look at the transpose function.  It is a bit complicated to use so be sure to read the detailed notes about the function. The complete descriptoin includes examples.

     

    Untitled.jpg

  • Wayne Contello Level 6 Level 6 (15,805 points)

    you can transpose (which is really a swapping of the row and column) using the OFFSET() function.  Are you wanting to turn a row into a column?  or a column into a row?  or are you wanting to transpose a who table?

     

    In either case you can have the original data in a table (let's call it Data) and the transposed data in a new table... lets called it Trans

     

    Screen Shot 2013-08-29 at 8.42.24 PM.png

     

    The table on the right is "Trans"

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

     

    select A1 and fill to the right as needed

    select A1 thru the end of the row, then fill down as needed