This week, I take a look at how extracting data from multiple lists can be confusing when nulls are involved.

Welcome to our Power Query blog. This week, I take a look at how to pass Excel data as a parameter in Power Query.

Welcome to our Power Query blog. This week, I take another look at what I can do with Excel.CurrentWorkbook.

This week, I take a look at the latest improvements to the ‘Add Column from Examples’ functionality...

Welcome to our Power Query blog. This week, I take a look at how to reference a cell in an Excel workbook from Power Query.

Previously I looked at a few ways to share queries between workbooks. This week, I take a look at a slightly different approach...

Welcome to our Power Query blog. This week, I take a look at a way to create and append new queries by starting with the Query Editor.

Welcome to our Power Query blog. This week, I take a look at exporting queries to other workbooks in Power Query or Get and Transform.Regular readers will know that this blog is now constructed in Excel 2016 and therefore uses ‘Get and Transform’. In most cases, it’s...

Welcome to our Power Query blog. This week, I look at the ‘Query Options’ screen and what it can do for me.

Welcome to our Power Query blog. This week I look at renaming many columns in one step.