Is there a way in Numbers to flip columns with rows ?

I have several tables in my sheet and I need to swap columns with rows for each table.


A1  A2  A3
B1  B2  B3
C1  C2  C3

should become:

A1  B1  C1
A2  B2  C2
A3  B3  C3


  • 3
    This is called 'transpose' – CousinCocaine Jun 16 '15 at 16:49

You have a one-year old question in Super User about this.
It links to an Apple forum page where you will be told to how to use INDEX and TRANSPOSE functions to achieve what you're looking for.
The Past Special of Excel is way easier but this function is not widely used so apparently dropped from Numbers.


With the table selected, simply choose Table > Transpose Rows and Columns.

  • how do you select the table though? – tubbo Feb 3 '16 at 17:55
  • 4
    @tubbo Click it. – Tuesday Feb 3 '16 at 17:55
  • Remark: Feature not available in Apple Numbers 2.x (from iWork '09 suite). – porg Jan 19 '17 at 18:00

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .