The Power Query Magic YouTube version is available here... https://youtu.be/07zOX5IYImI   Gil is author of the excellent book Collect, Combine, and Transform Data Using Power Query in Excel and Power BI https://datachant.com/next/   We discuss Gil's experience as one of the Program Managers on the Excel team where he was closely involved with Power Query in it's earliest days.   We discover one of Gil's first ever blog posts was the inspiration for my first ever YouTube video Gil's post: https://p3adaptive.com/2015/05/harness-power-query-to-gain-competitive-analysis-insights-from-linkedin/ My Video: https://youtu.be/uej_Uc3__bE Links:   Gil's App Source Apps: https://appsource.microsoft.com/en-us/marketplace/apps?page=1&search=datachant   Most Popular Article https://datachant.com/2016/12/09/remove-empty-columns-rows-from-table-in-excel-power-query/ Favourite Articles: https://datachant.com/2019/10/17/bad-practices-power-bi-pie-charts/ https://datachant.com/2017/01/06/10-mistakes-you-always-do-in-powerbi-powerquery/