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