Unpivot Multiple Column Pairs In Power Query

We are going to unpivot multiple column combinations in this video. This is part of the Unpivot Variation series which is all about turning your data into a proper tabular format that is suitable for analysis. I will also explore how we can use List.Zip() to unpivot sets of data in Power Query. ***** Video Details ***** 0:35 source table 1:13 data pairs and 3 overtime types 2:15 adding custom column - List.Zip 4:11 how to remove value columns 4:39 expand to new rows and generated 3 records 4:52 extract values function 5:10 split by delimiter ***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download/ Enterprise DNA Membership - https://enterprisedna.co/membership Enterprise DNA Online - http://portal.enterprisedna.co/ Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/