Change Data from Rows to Columns (or vice versa) - Transpose in Excel #shorts

In this super #shorts Excel video learn a simple Microsoft Excel hack to switch data in horizontal rows to a nice vertical data set. On top, we'll make a perfect summary report to make your boss happy.

Let’s connect on social:

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

[Commonzenze]

You don't know how many times I have needed to do this but didn't know it was even possible, thanks!

[wayneedmondson]

Thanks Leila! Always fun to watch your videos :)) Thumbs up!!

[caharsha]

Really felt awesome on seeing the way the content is presented. Superb ❤️

[WhosShamouz]

That's probably one of the coolest #shorts I have ever seen lol. Amazing music, quality and ending ☺

[homosapienas]

Shift down
Ctrl shift right
Ctrl c
Paste
Paste special
Transpose
Insert
Insert pivot

[phpvbacoder]

Nice 👍
I used vba for that work. But that is way faster. Thanks!

[ahmadkhalil]

you always kind leila thanks for sharing this with us.
you are the best

[vijayarjunwadkar]

Weekend #shorts are just what the doctor ordered to prepare us for the week to follow! 😁👍 Keep them coming Leila!

[aatariq]

Please make a video on "10 Excel Shortcuts to impress your boss"
Or
"10 Office shortcuts to impress your boss".

[roywilson]

Love it! God bless all bosses who think they know how to use Excel, they keep us employed sorting out their messes :D

[kapil]

This is really welcome step to bring short videos. Please keep it up on regular basis, preferably twice or thrice a week. Thanks in advance !

[JCEurovisionFan]

Ma'am Leila, will you do a tutorial on Benford's Law?

[MichaelStrong]

Thank you, Leila. Transposition is definitely handy, but the basic operation that I often need is simply to swap columns or rows; one column for another, or one row for another. Why is it so hard to find help for this basic operation?

[zeinababdel-rehim]

Hi Leila, I have a question please could you record a video to explain how we can change the cell background depend on a selection from a dropdown list (if it's selected)

[afzalmohammed]

:) ☺ creative way to present, full attention due to background music...nice

[victorsalinassilva]

where were you when I had to do this for months 😜

[countduckula]

Why do people record data in rows?
Thank you for showing the solution.

[naboulsikhalid]

this is original from you LEILA. but always, you are ahead and creative. thank you. nice weather is Montreal(canada)

[ultimategames]

i understand the solution when you have 1 time off action. but what i see regular is these kinds of data receiving from a report or external party like more regular. for instance once a week or month etc. then this action is not effecient. you don't even have to use a macro. i think this case is more interesting.

[remars-xcel]

its almost Winter, the best time of the Year #EXCELHASH