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 that is of interest, let me know what types of Pivot Tables you are trying to replicate (specifics will help) and I'll post.If Numbers is your spreadsheet application of choice, then you likely know about its terrific features. I select the cells with the data, click, and the table appears, somewhat similar to Excel. If you are doing a lot of this kind of analysis I have an AppleScript that removes some of the tedium by automatically setting up the table with the SUMIFS. And you can use the new summary table as a basis for further calculations and for charts. This (which you can also do in Excel, by the way) requires a little more setup than a pivot table but you get to the same place. You can add more column-condition pairs as needed. So the formula here in B2 is saying, add up all the numbers in column C of the data table (the first argument) where the value in column E of the Data table is the same as the value in A2 (the first column-condition pair) and the value in column D of the Data table is the same as the value in B1 (a second column-condition pair). The following arguments are column-condition pairs, where each condition applies to the column just before it. The first argument within the () is the column you want to sum. If you look up SUMIFS in the function browser you'll see how it works. However, you can create a 'cross tab' type view of your data using SUMIFS. There is no direct equivalent in the Numbers user interface, where you can create (and modify) pivot tables with a few clicks and drags.

How to make pivot table in mac numbers