There are FOUR videos associated with this page as well as my Excel file and they are all free to watch/download.

Get & Transform is also known as Power Query and it keeps getting better and better. They just announced updates for January 2018 and they are a bit magical so I have prepared this pages, the videos and my Excel file to share my joy with you!

Everything is explained in the files so without further adieu, here you are. Your comments are more than welcome, as always.


Duncan Williamson

31st January 2018

Download Area 

Video 1 Bucket/Bin Ranges 

Video 2 Positive/Negative Association 

Video 3 Positive/Negative Association Explained in Full 

Video 4 Creating Associated Lists 

Excel File … G&T_updates_jan_2018_part_2

%d bloggers like this: