Ask Different is a question and answer site for power users of Apple hardware and software. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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


share|improve this question
This is called 'transpose' – CousinCocaine Jun 16 '15 at 16:49
up vote 2 down vote accepted

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.

share|improve this answer

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

share|improve this answer
how do you select the table though? – tubbo Feb 3 at 17:55
@tubbo Click it. – timothymh Feb 3 at 17:55

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.