18

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.

e.g.

A1  A2  A3
B1  B2  B3
C1  C2  C3

should become:

A1  B1  C1
A2  B2  C2
A3  B3  C3

thanks

1
  • 3
    This is called 'transpose' Jun 16, 2015 at 16:49

2 Answers 2

3

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.

35

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

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

You must log in to answer this question.

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