This blog outlines seven mind-blowing Power Query tricks, including promoting headers without a promoted headers step, extracting any intermediary step, dynamically expanding tables, using projections, and utilizing the ‘sections’, ‘is’, and ‘&’ keywords!
I Bet You Don’t Know all these Power Query Tricks