Move a column of names to be a row of names.
Paula asks how to take a range and turn it on its side. Episode #1173 shows you how.
Paula asks how to take a range and turn it on its side. Episode #1173 shows you how.
Transcript of the video:
MrExcel podcast is brought to you by ”Easy-XL”!
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Well, today's question sent in by Paula, Paula lives in Washington.
Paula sent me a spreadsheet with different data, which I've changed to kind of protect the confidentiality there.
Paula says “Hey, I need to take that yellow range and turn it sideways into the blue range.” Alright, and most of our Excel pros here are going to know this is something called transpose.
Transpose traditionally was on the Paste Special dialogue, and we'll do that first.
So we're going to copy this, I'm going to use Ctrl+C to copy, and then come up here to C13, and we're not going to paste, we're going to Paste Special!
So we can use Paste, Paste Special, and then down here at the very bottom is something called Transpose, click OK, alright!
So now if you're new to transpose, I need to call out one interesting problem with transpose.
I, like Paula, had a question “How do I take Albertsons and move it to Albertsons?” Really, if you think about this, she could have asked “How do I take this range,” let's make it the green range, “and move it to be in this area?” I mean, that would be just a very natural thing to want to do, right.
But unfortunately transpose will not let you do that.
Ctrl+C to copy, and then if we come up here and try and do Paste, Paste Special, Transpose, well the problem is going to be that the paste range includes one cell in common with the copy range.
So when I click OK, the selection is not valid, you're not allowed to overlap when we're doing transpose.
So you have to be very careful that you are going to a new spot, Special Transpose, and that will work.
Now, if you're in Excel 2007, it's even easier, you can do the copy, select the new cells, and then just use Paste Transpose, and that will turn sideways.
In Excel 2010, it's going to be even easier with that great new visual Paste Options dialog box, but we'll have to wait for Excel 2010 to get to that.
So I want to thank Paula for sending that question in, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
Hey, just a quick note from our sponsor Easy-XL!
The folks at Easy-XL are frustrated that you cannot transpose in place.
So check this out, Cells, Transpose Selected Cells, click OK, and you can actually transpose right in place.
Cool!
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Well, today's question sent in by Paula, Paula lives in Washington.
Paula sent me a spreadsheet with different data, which I've changed to kind of protect the confidentiality there.
Paula says “Hey, I need to take that yellow range and turn it sideways into the blue range.” Alright, and most of our Excel pros here are going to know this is something called transpose.
Transpose traditionally was on the Paste Special dialogue, and we'll do that first.
So we're going to copy this, I'm going to use Ctrl+C to copy, and then come up here to C13, and we're not going to paste, we're going to Paste Special!
So we can use Paste, Paste Special, and then down here at the very bottom is something called Transpose, click OK, alright!
So now if you're new to transpose, I need to call out one interesting problem with transpose.
I, like Paula, had a question “How do I take Albertsons and move it to Albertsons?” Really, if you think about this, she could have asked “How do I take this range,” let's make it the green range, “and move it to be in this area?” I mean, that would be just a very natural thing to want to do, right.
But unfortunately transpose will not let you do that.
Ctrl+C to copy, and then if we come up here and try and do Paste, Paste Special, Transpose, well the problem is going to be that the paste range includes one cell in common with the copy range.
So when I click OK, the selection is not valid, you're not allowed to overlap when we're doing transpose.
So you have to be very careful that you are going to a new spot, Special Transpose, and that will work.
Now, if you're in Excel 2007, it's even easier, you can do the copy, select the new cells, and then just use Paste Transpose, and that will turn sideways.
In Excel 2010, it's going to be even easier with that great new visual Paste Options dialog box, but we'll have to wait for Excel 2010 to get to that.
So I want to thank Paula for sending that question in, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
Hey, just a quick note from our sponsor Easy-XL!
The folks at Easy-XL are frustrated that you cannot transpose in place.
So check this out, Cells, Transpose Selected Cells, click OK, and you can actually transpose right in place.
Cool!
