Transpose, pivot or unpivot in Power Query?

In todays video I am going to show you what Transpose, pivot and unpivot is and examples on when to use each or all at once!


Chapters:
00:00 Intro
00:12 What is transpose in power query?
00:22 What is pivot?
00:27 What is unpivot?
00:35 Example where transpose is better fit that pivot
01:34 Example of transpose and unpivot
03:09 Example of transpose, pivot and unpivot
Done!

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:


Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲


************





************


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[valenmolina]

I've been struggling for hour with a table that was given to me in the wrong format and with this video I could fix everything and get started on my report. Thanks a million!!

[bibekanandabhattacharjee]

I understood just the definition. However, thanks @Curbal for igniting the interest in me.

[Tony-uvpd]

Thank you for the simple explanation. Sometimes, it can get confusing. But this video is a great reference!

[kiddwong]

This is exactly the video I needed to help me reconfigure some data I had in a rubbish format. Thank you so much!

[imconfused]

Ruth, thank you sooo much for demonstrating how to use these techniques. It has instantly solved a huge headache, where our Data Model had to monthly injest 20k rows. Using this, I am now able to: pivot the data at source, extract as a PDF, import into PowerBI and then use the 2nd technique to transpose + unpivot it back into a useable dataset. Absolutely superb!!!! 👍

[raniakkina]

Thank you for explaining things so clearly. This concept always used to confuse me.

[joangarcia]

La mente humana es algo maravilloso: hace unos dias vi este video sin entender demasiado. Hoy me encuentro creando un informe, en una tabla que no quedaba bien y.... zas! “Ese video....” lo he vuelto a ver y aquí estaba la solución.

[Pedro_Israel]

Didn´t know how to put into words what I was looking for: "Unpivot" is the answer. Thanks.

[joat]

you save my life, my god this is very helpful thank you very much mrs

[siyabongamyeza]

This is a very deep concept. Thanks for making it short and straight to the point

[carltonseymour]

Thank you, Ruth. This video solved a nagging issue a colleague was trying to soolve.

[mikesmith]

thankyou for this. The best explanation i have seen.

[enochs]

Thank you! Just the first examples you showed in the first minute answered my questions!!!

[Gustavo-Santana]

Thanks for the great content :), for Q2 I believe the answer is number 4: Microsoft Azure SQL Database

[eshwarkotha]

Many thanks for this valuable session
I have understood clearly about transpose pivot and unpivot and very useful topic and these topics will be implemented on my work

[rmmccarthy]

Thank you. This has helped me a great deal.

[pandianselvaraj]

Thanks for u
Yr explanation about transpose, pivot and pivot...
For Q2 :i choose option 3( Microsoft azure HD insight )

[ReisdoBI]

It was one of the most helpfull things I watched in youtube this year!
Thanks a lot!

Abraços do Brasil!

[ericdowdy]

Great explanation on 3 key tools in power query for shaping data! Thanks Ruth!

[adityapuro]

Curbal, your content helped!! Thank You! Keep Growing!