3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa)

Save
2 years ago
126
transpose excel Excel transpose formula Excel Tutorials transpose without array Excel trick to transpose Excel paste as transpose excel transpose columns to rows transpose without copy paste excel will not transpose excel hacks rotate data in excel

‍‍‍‍Nov 8, 2018 Excel Hacks: Tips & Tricks
‍
‍Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials

Check out 3 ways to Transpose your data in Excel. These are useful when you want to switch the orientation of your data from columns to rows or vice versa. I show you how to:

00:00 Switch Data from Rows to Columns in Excel - or Vice Versa
00:25 Static approach - copy and paste as transpose
00:54 Use the Transpose Function to Rotate Data
02:54 Use a Simple Formula Trick to Transpose

Note: Once you get dynamic arrays, writing the Transpose function becomes super simple. You no longer need to highlight the result area first, nor press control + shift + enter.

DOWNLOAD the workbook: https://www.xelplus.com/transpose-excel-data/

★ Links to related videos:
Transpose Excel Hack for horizontal to vertical data: https://youtu.be/dF0cVRyC8c4
Dynamic Arrays video: https://youtu.be/2USJsIyIzvo

★ My Online Excel Courses ★

Courses ► https://courses.xelplus.com/

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

★ Excel Resources I Recommend
https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel

Loading comments...