Transpose, Unpivot and Pivot in Power Query - Understand the difference

[@YouExcelTutorials]

Please subscribe and check out other useful tutorials on my channel. Thanks!

[@fliptop157]

Thanks- this video was helpful in my understanding!

[@DrK99999]

Super helpful to clear the basics👍👌

[@YouExcelTutorials]

I'm glad you found it useful dk!

[@Giridharan952]

Excellent and to the point. ... Nice madam

[@YouExcelTutorials]

Thanks Giridharan! I'm glad you found it useful

[@vijayarjunwadkar]

Well, I tried these features in Power Query, but struggled! However, you have explained it so well, that now I am confident of using them in different situations! Thanks a lot! 😊👍

[@YouExcelTutorials]

Thanks Vijay! I'm glad you found it useful. Don't forget to share with others who might also find it useful.

[@udaracperera]

Thank you. I was wondering for a long time

[@YouExcelTutorials]

I'm glad you found it useful. Thanks Udara!

[@jerrymabasa1068]

Content worthy of going through, I have been struggling with this subject

[@YouExcelTutorials]

Thanks Jerry. I'm glad you found it useful.

[@flowerpixel]

Great simple example thank you 👍

[@YouExcelTutorials]

I'm glad you found it useful. Thanks for watching Holly!

[@Sridhar-k8p]

What an explanation, super mam

[@cheikhhakim5864]

lot of thanks

[@YouExcelTutorials]

You're welcome!

[@Devloper56]

Great !!!!!

[@gregcalvert4645]

🔥🔥🔥

[@mon_rich5366]

the best

[@JJ_TheGreat]

8:33 That is incorrect. There are 2 "distinct" values, not 2 "unique" values. They are 2 different things. Distinct values are all of the values in your data set AT LEAST once. Unique values, on the other hand, are values which are in your data set ONCE AND ONLY ONCE. Therefore, distinct values are composed of unique values and non-unique values (i.e., values with duplicates). Therefore, you have 2 DISTINCT values of years (2019; 2020), but 0 UNIQUE values of years.

[@YouExcelTutorials]

Thanks for catching that J.J.!