Рет қаралды 503
Have you ever wanted to flip your data from horizontal to vertical, or the other way around? Maybe you have a list of names that you want to turn into a column, or a table that you want to rotate 90 degrees. Well, guess what? You can do that in Excel with just a few clicks. And I’m going to show you how in this video. There are three different methods to transpose an address or range in Excel: The Paste Special option, using the TRANSPOSE function or “surprise” another cool dynamic array function. I’ll walk you through each one and show you some examples of how they work. By the end of this video, you will be able to transpose any address or range in Excel like a pro.
0:00 Intro
0:39 Copy / Paste Special (Transpose)
1:13 TRANSPOSE Function
2:21 TOROW & TOCOL Functions
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to
www.buymeacoff...
#excel
#msexcel
#doughexcel