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

preview_player
Показать описание
This video describes how to distinguish between transpose, unpivot and pivot with practical examples. You will learn how transform your data into a proper structure suitable for further analysis.

Please check out other videos on my channel and don't forget to comment, like, share, subscribe and click the bell icon so you'll get a notification when the next video is uploaded. Thanks!

Content
00:00 Intro
00:40 Transpose in Excel
01:45 Transpose in Power Query
03:40 Unpivot data with single header
05:45 Unpivot with multiple headers
08:05 Pivot and aggregate data
Thank you

Connect with me on:
👉Instagram and Facebook @youexceltutorials
👉Twitter @youexceltutor
👉LinkedIn @bunmisanusi

🎬Check these videos:

📢“And we know [with great confidence] that God [who is deeply concerned about us] causes all things to work together [as a plan] for good for those who love God, to those who are called according to His plan and purpose.” Romans 8:28 (AMP)

#msexcel #youexceltutorials
  1. YouExcel Tutorials
  2. #microsoftexcel
  3. #msexcel
  4. #powerquery
  5. #dataanalytics
  6. #youexceltutorials
Рекомендации по теме
Transpose, pivot or 0:05:26

Transpose, pivot or unpivot in Power Query?

To Pivot or 0:06:19

To Pivot or Unpivot? That is the question!

Pivot/Unpivot PowerBI Feature 0:03:32

Pivot/Unpivot PowerBI Feature explained | Power Query | MiTutorials

Transpose, Unpivot and 0:10:21

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

Convert Columns to 0:05:00

Convert Columns to Rows in Excel (NO Transpose, NO Formulas - SIMPLY UNPIVOT in Power Query)

Excel Unpivot Data 0:13:30

Excel Unpivot Data with Multiple Headers (Multiple Row levels into Columns with Power Query)

Power Query Unpivot 0:19:24

Power Query Unpivot - fix 4 common data layouts (incl. workbook)

Getting Data Ready 0:15:37

Getting Data Ready for a Pivot Table - Unpivot | Pivot | Transpose

1.5. Transpose, Pivot, 0:17:52

1.5. Transpose, Pivot, Unpivot in Power Query | Power BI for Everyone

Difference between transpose, 0:01:43

Difference between transpose, pivot & unpivot in Excel's PowerQuery

UNPIVOT: Data Cleaning 0:04:57

UNPIVOT: Data Cleaning Power Tricks 💡

PowerQuery- Pivot, UnPivot, 0:04:17

PowerQuery- Pivot, UnPivot, Transpose

Combine complex data: 0:30:23

Combine complex data: Transpose - Unpivot - Pivot columns

SQL Query - 0:04:56

SQL Query - Convert data from Rows to Columns | Pivot

Pivot & Unpivot 0:03:46

Pivot & Unpivot in Excel Power Query

SQL Convert Rows 0:08:54

SQL Convert Rows to Columns and Columns to Rows without using Pivot Functions

Transpose, Pivot, Unpivot, 0:38:03

Transpose, Pivot, Unpivot, Reverse in Power BI

Advanced Unpivot in 0:06:28

Advanced Unpivot in Power Query - Transpose Multiple Columns & Multiple Headers Without Any Form...

Transpose vs UnPivot 0:03:05

Transpose vs UnPivot | Power Query | Power BI

Why UnPivot in 0:12:13

Why UnPivot in Power Query (2 Ways)? Transpose, UnPivot, Pivot.

Power BI Pivot: 0:07:25

Power BI Pivot: Move Data from Rows to Columns #Q&A

Dealing with DOUBLE 0:09:51

Dealing with DOUBLE HEADERS in Power BI using UNPIVOT, TRANSPOSE, and FILL DOWN

Transpose & Unpivot 0:06:44

Transpose & Unpivot

Unpivot Cross Tabulated 0:06:34

Unpivot Cross Tabulated Data with Multiple Headers and Columns

Комментарии
Автор

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

YouExcelTutorials
Автор

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! 😊👍

vijayarjunwadkar
Автор

Excellent and to the point. ... Nice madam

Giridharan
Автор

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

jerrymabasa
Автор

Thanks- this video was helpful in my understanding!

fliptop
Автор

Thank you. I was wondering for a long time

udaracperera
Автор

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.

JJ_TheGreat