Hi, this is Wayne again with a topic “Transposing Columns into Rows in Excel”.
In this short excel tutorial, I’m gon na show you how to transpose columns into rows in Excel. So here we have a spreadsheet of someone’s personal movie collection, and you see the titles here and some information about those titles over here on the side. Now, let’s say I’m building this spreadsheet and then I decide I did it wrong instead of having column titles here across the top. I really would like them to be row titles and to have them listed here vertically. Sometimes your purpose for the spreadsheet changes and therefore the design has to change, and so, when that happens, to you, this is how you can transpose columns into rows step. One is to click in the upper left corner of the range of the data, so my data is really right here. That’S the heart of my data of my spreadsheet, so I’m just gon na click in the upper left corner and drag to the lower right corner.
Now perhaps you’re really looking to transpose the entire spreadsheet, it is possible to select the whole spreadsheet. You can click this button here in the upper left and it should select all of the data. But in my case really all I want to transpose is that information there so now that it’s selected copy that range – and I did that by holding ctrl and tapping, see but there’s other ways to copy, of course. Next, in order to transpose this in a clean way, I’m gon na recommend going to a second sheet, so I’ve been working on sheet one, but I can click on this button here to add a second sheet.
It called it sheet 3, but I’m gon na rename that and call it sheet 2 and now I’m just gon na go to cell a1, and now I need to paste in the data, but not a regular paste. Instead, I need to go here to paste special and when you click on paste special, it gives you a list of some special ways to paste, as you would guess, one of those is to paste, while transposing so click that and then click ok and look now All of my data in that spreadsheet has been transposed, columns have become rows and rows have become columns. Now I can clean up this data pretty easily. You can see a lot of it doesn’t fit in the provided space, but if I click and drag and highlight all of the column letters I can then double click between any two of the column, letters right on the line between them and that should automatically resize. All of the columns so that the data inside them can fit perfectly if it’s not about making everything fit perfectly, but you just want them all the same width.
You could click and drag and make them identical in width. So I have successfully transposed columns into rows and now I can delete sheet one I’ll, just right-click on that and delete it. If I’m sure I don’t need it and then of course maybe I changed my mind and wish I hadn’t deleted it.
Well, that’s! Okay! It’S the same exact process to transpose back, highlight the data. That’S important copy create another sheet, find a blank space in the sheet. It’S all blank for me, I’ll, go to a1 right-click paste special transpose and now we’re back to my original layout.
Again, I could adjust those column widths to make it so that everything fits thanks for watching this tutorial. I hope you enjoyed it if you did. Please click the like button below and consider connecting with me on my social media accounts like Facebook, Pinterest and Twitter, and definitely do subscribe to my YouTube channel for more videos about technology for teachers and students and when you do subscribe, click the bell. Next to the subscribe button, if you do you’ll be notified whenever I post another video and watch for another video from me at least every Monday, if you’d like to support my channel, become a supporter of mine through my patreon account and you’ll see a link to That in the description below speaking of patreon, I want to give a shout out to my five dollar patreon supporters, including Charmin Kurt Joshua, Craig Aaron Bill and Nicole. Thank you so much for supporting my channel. I also appreciate all of my patreon supporters, those who donate fewer than $ 5 a month. I appreciate you as well: Oh .