Power Query - Pivoting Stacked Data скачать в хорошем качестве

Power Query - Pivoting Stacked Data

**** UPDATE: Check out some AMAZING alternate solutions proposed by the viewers in the comments. Some of these are NEXT LEVEL cool! **** Learn two methods for transforming stacked data into proper tables. Skills include Modulo division, Integer division, Pivoting, creating number sequences, and creating lists of looping numbers. All great tricks for solving a variety of problems. File Download Link: https://www.bcti.com//wp-content/YT_D... 00:55 Solution 1 - Selecting the data 01:03 Preventing unwanted table upgrades 01:38 Alternate method for starting Power Query sessions 01:54 Zooming in/Out of the Power Query Window 02:09 Pattern Recognition in Power Query 02:47 Creating a list of sequential numbers 03:10 Creating the repeating list using MODULO division 03:49 Pivoting the list of repeating numbers 05:53 Solution 2 06:12 Creating numbers to identify complete records 06:49 Transform sequential list to repeating list 07:26 Advantage to Solution 2 08:00 Building charts from the results 08:39 List of all steps performed