So, be cautious that these may unmerge after transposing. If you have merged cells, they should transpose as any other cell unless they are a row header.

Chart references should remain the same after transposing.Formulas and functions should remain after transposing, and you will receive a warning if there is an issue.Table styling, such as colors, highlights, and cell outlines, should retain their style when transposing.Your rows and columns will go back to their original locations. If you decide you want to revert the transposition on either Mac or iOS, just follow the same steps to access and select the Transpose Rows and Columns option. Open the Numbers app on your iPhone or iPad, access the spreadsheet you want to change, and follow these steps:ġ) Like on Mac, select the table by tapping on it.Ģ) Tap the circle on the upper left corner of the table.ģ) The Table Actions button will display at the bottom in green.Ĥ) Tap that button and select Transpose Rows and Columns. Your spreadsheet will automatically update, reflecting this change. The transpose tool will not be clickable unless your table is selected by clicking on it. Next, do the following:ġ) Select the table. Pop open Numbers on your Mac and open the spreadsheet you want to change. Transposing rows and columns in Numbers On Mac Here’s how to transpose rows and columns in Numbers with just a couple of clicks. But you no longer have to do that, and it’s even easier than the method in Microsoft Excel. This used to be a tedious task of sorts because you had to insert a formula. You might want to convert your rows to columns or vice versa. So, when you are working with your spreadsheet data, you may decide part of the way through that you want to format that sheet differently. Numbers has tons of templates to get you started, hundreds of functions you can use, methods for collaboration, and so much more. If Numbers is your spreadsheet application of choice, then you likely know about its terrific features.

Transform columns to rows in excel