How to EASILY Switch Columns to Rows in Excel #shorts

In this video I'll show you two magic tricks to switch data from columns to rows in Excel. This way you get to easily transpose your data in Excel. You'll learn a two click method and you'll also learn how to use the TRANSPOSE function so you can automate it.

🚩Let’s connect on social:

👉 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!

#Excel #shorts

[Weyru]

This video is actually life changing for me.I can’t believe the number of times I have needlessly retyped my data.

[besttech]

I love those small videos, they are short, easy explained and to the point. Thanks 😊

[DaveAMcLaughlin]

Thank you for all of the wonderful tips, Leila! :)

[bali]

Didn't know about that transpose function. I cry for all the time I wasted over the years without it. But I'm grateful for the time it'll save me from now on... Thank you.. 👍

[wayneedmondson]

Great Leila! For anyone needing a legacy formula, this will work: =INDEX($A$2:$F$3, COLUMNS($A22:A22), ROWS(A$22:A22)). Copy down and right. Thanks for the short vids.. always fun and informative :)) Thumbs up!!

[HeatherMajors]

As always a cool and helpful tip to save time. Thanks!!

[Yvon]

Ohhh. Wish I would have known this last week. It would have saved me much time. Thanks for always teaching me something new.

[theeactivone]

Oh how I would love to have your Excel-Mind!!

[sachinrv]

Transpose is wonderful. In fact when the data size is huge, one case use combination of if, offset, mod, row and get it transposed in no time. Please post one video on this combination which will be extremely useful.

[Maya-svpz]

and... I learn something new again (second method) from Leila despite being a pro transpose paster for many months using the first paste special method. thank you.

[petr]

I have one tip: A1: 10, B1: =$A$1 (absolute address). If you need to copy this "closed ecosystem" elsewhere, use double transposition (Paste Special / Transpose). For example: G3: 10, H3: =$G$3.

[darthvader]

Lovely, just what I need at the moment.

[Minji_Hanni_Dani_Haerin_Hyein]

Cô giáo giảng bài rất dễ hiểu. Xin cảm ơn

[leaferrariz]

Thank you for this... can we do it from columns to rows? Thanks.

[JJ_TheGreat]

Wow! So I really didn’t need to transfer the data over to Power Query just to do one transpose! This will save a lot of time!

[theblissfulgallery]

Very interesting & informative!

May I know what are the maximum no of worksheets in excel

[bradleydawson]

I still copy, then use alt+e+s+e, old school. These look more direct

[ajayrajacharya]

Hi Leila, all your videos are very informative , can you make one video on HOW TO WRITE CHEQUES from Excel, if we place 1 or two cheque in printer and from excel by filling 4-5 details all information in filled in one template which is synced as per size of cheque and by CtrlP cheque can be printed, info is available on internet but confused about the best method !

[rofreemail]

Love your videos thank you, I have a question can you transpose formulas?

[amitshuklamusic]

Any excel function to unpivot few columns in excel how we do it in power BI