Transpose a Table in a Numbers Spreadsheet

0:00
In this video, we’re going to look at how we transpose a table in a Numbers document. We’re going to look at this on the Mac, iPad and iPhone. Let’s first look at this on my Mac. Now, you may be wondering what transposing a table is in a Numbers document, basically, what we’re doing is we’re flipping around our columns and rows. Let’s go and open up a new Numbers document, I’m going to go down to Numbers here. Now what I’m going to do is create a new document, I’m going to create a new document based on schedule. When we look at the schedule here, this table, you’re going to see that across the top, I have the different days. And with our rows, I have the times, what I would like to do is transpose this, I’d like to flip this around. That’s what we do when we transpose it. Instead of having our times on the left here as a row, what we do is we put the time across the top. And then what it does is it moves these days to these rows here, we’re just flipping this around.

So how do we do that? Well, we first have to select our table. So I click in there, click anywhere in that table. And then what we do is we go up to table, and you’re going to see transpose rows and columns, all I have to do is just select this. And we can see that it flipped them around my days. Now our rows, and my times are across the top as columns. So it just flipped those around. To flip them around again, I just go up under table. And then we go over to transpose rows and columns. And then it flips them around. Now you may be wondering what this little blue triangle here is, basically, that’s a comment. When I click on it, what I’m able to do is see that a formula was updated, it’s just telling me that something was updated. And if I want to remove that comment, all I have to do is just go to common here. And when I click outside there, removes that comment. So that’s what transposing is and how we do it on the Mac. Let’s see how we do this on the iPad next. So I’m going to go over to my iPad here. So I’m in Numbers here, let’s go and create that same document that same type of document from the same template. So I go over to create spreadsheet. And then I go over to schedule.

Under schedule, we can see that we have our days across the top, and our times across the side, I want to transpose these, I want to flip these around. Well on the iPad, what we need to do, if we have a keyboard for our pad, what we need to do is select the table. And then what we do is we go over to the.in, the upper left hand corner of the table itself. So we can see that with my pointer, I have a little dot here. If I hold down the Control key and click, what I have here is transpose table. So if you have a keyboard, it’s real simple, we just first select the table, and then we go to the data up here in the upper left hand corner of that table Ctrl click, and we can transpose it.

Now what happens if you do not have a keyboard? Then what do you do? Well, basically, you have to tap on this little data again. So again, what we need to do is we need to make sure that the table is selected, so I’m just going to tap on it with my finger. And then I go up to the.in, the upper left hand corner, we have a menu that pops up. And from here, what I do is I can go to table actions, or what we can do is go down to table in the lower right hand corner. And when I tap on it, I’m able to transpose it. So let’s go ahead and transpose it. And now we can see it flipped it around. So if you have a keyboard, you can Control click. And if you do not have a keyboard, then you just have to tap on little die here, and then go to table actions or just go down to table in the lower right hand corner. Now what about the iPhone? How does it work on the iPhone? Well, let’s go over to my iPhone and see how this works. It basically works the same way as the iPad, as you can imagine. So I’m going to create a new spreadsheet. So I tap on the plus in the upper right hand corner. And then I go over to my schedule, we’re going to use the same template.

It creates a spreadsheet we can see we have the days across the top with the times across the side, I want to transpose this. Well, I don’t have a keyboard for this. So what do you think we do? Well, we tap in here to select the table. And then we go to the upper left hand corner of that table where that little data is it’s underneath my pointer here. When I tap on that die, what we’re able to do is go over to table actions, or what’s easier is just go down to the lower right hand corner to table here. And when I tap on it, what I can do is I can transpose it. So now I just tap on transpose, and we can see it flipped it around. So that is how you transpose A Numbers table on the Mac, iPad and iPhone. On the Mac, what we need to do is select the table doesn’t matter what we select, we could select a cell. But basically we just have to select something in that table and then we go to table in the menu bar, you’ll see transpose on the iPad and iPhone, what we need to do is tap on the table itself. And then we go over to the data in the upper left hand corner of that table. And then from there, what we’re able to do is transport we go to table in the lower right hand corner, it’s going to be a green button. Tap on that and then we can transpose it. So that’s how we transpose tables and Numbers on the Mac, iPad and iPhone.