Sign up ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

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 at 16:49

2 Answers 2

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

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.