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.



  • Wayne Contello Level 6 Level 6 (16,145 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