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:
Intro to Power Query [ Ссылка ]
Power Query and Power Pivot [ Ссылка ]
Pivot Tables [ Ссылка ]
🔽Download the file here [ Ссылка ]
📢“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
