Check out our newly launched M Language course ↗️ - https://goodly.co.in/learn-m-powerquery/
In this video, we'll explore the solution from the last Power Query Challenge!
➜ Download My Solution + Other solutions in the blog comments
https://goodly.co.in/convert-multiple-column-groups-to-rows-power-query/
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
https://goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
https://goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
https://goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
https://goodly.co.in/learn-excel-dashboards/
===== LINKS 🔗 =====
Blog 📰 - https://www.goodly.co.in/blog/
Corporate Training 👨🏫 - https://www.goodly.co.in/training/
Need my help on a Project 💻- https://www.goodly.co.in/consulting/
===== CONTACT 🌐 =====
Twitter - https://twitter.com/chandeep2786
LinkedIn - https://www.linkedin.com/in/chandeepchhabra/
Email - [email protected]
===== CHAPTERS =====
0:00 Intro
0:19 Revisiting the Problem
0:58 Problems with Transpose Operations
1:43 Formative Understanding of the Solution
2:43 Extracting the Names of the Column
4:18 Converting All the columns in 'List' format
6:48 Creating Pair of Two
10:22 Make the Pair Count Dynamic & Get Locations
12:53 Combine Locations and Column Pairs
15:50 Shoutout & My Courses
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!
- - - - -
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
- Source: https://goo.gl/fh3rEJ
Official After The Fall YouTube Channel Below
https://www.youtube.com/channel/UCGQE...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: https://creativecommons.org/licenses