How to transpose rows and columns in Numbers on Mac and iOS

If Numbers is your spreadsheet application of choice, together with then you lot probable know most its terrific features. Numbers has tons of templates to larn you lot started, hundreds of functions you lot tin use, methods for collaboration, together with thus much more.

So, when you lot are working amongst your spreadsheet data, you lot may create upwards one's heed share of the agency through that you lot desire to format that sail differently. You powerfulness desire to convert your rows to columns or vice versa.

This used to endure a tardily chore of sorts because you lot had to insert a formula. But, you lot no longer have got to create that together with it’s fifty-fifty easier than the method inwards Microsoft Excel. Here’s how to transpose rows together with columns inwards Numbers amongst simply a distich of clicks.

Transposing rows together with columns inwards Numbers on Mac

Pop opened upwards Numbers on your Mac together with opened upwards the spreadsheet you lot desire to change.

1) Select the table. The transpose tool volition non endure clickable unless your tabular array is selected yesteryear clicking on it.

2) Click Table from your bill of fare bar.

3) Select Transpose Rows together with Columns.

Your spreadsheet volition automatically update reflecting this change.

Transposing rows together with columns inwards Numbers on iPhone together with iPad

Open the Numbers app on your iPhone or iPad together with access the spreadsheet you lot desire to change.

1) Like on Mac, pick out the tabular array yesteryear tapping on it.

2) Tap the circle on the upper left corner of the table.

3) The Table Actions push clit volition display at the bottom inwards green.

4) Tap that push clit together with pick out Transpose Rows together with Columns.

Reverting your changes

If you lot create upwards one's heed you lot desire to revert the transposition on either Mac or iOS, simply follow the same steps to access together with pick out the Transpose Rows together with Columns option. Your rows together with columns volition become dorsum to their master copy locations.

Things to croak on inwards mind

• Table styling such equally colors, highlights, together with jail mobile telephone outlines should retain their agency when transposing.


• Formulas together with functions should rest afterward transposing together with you lot volition have a alarm if in that place is an issue.


• Chart references should rest the same afterward transposing.


• If you lot have got merged cells, they should transpose equally whatever other cell, unless they are a row header. So, endure cautious that these may unmerge afterward transposing.


• Rules you lot have got created for sorting or filtering volition non apply afterward transposing.

For to a greater extent than on these weather or answers to questions, you lot tin view the Apple Support page on this topic.

Wrapping it up

Being able to convert rows together with columns is a terrific characteristic inwards Numbers that used to ask to a greater extent than work. In a few clicks or taps, you lot tin convert those rows together with columns speedily together with easily. Are you lot cook to have got wages of this handy feature?

Check out to a greater extent than from iDB on the Numbers app or roughly of our other tutorials for great tips together with tricks.

Share this post