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.

Welcome to our Power Query blog. This week I look at how to customise function descriptions by using M function meta-data.

Power Query and Power Pivot work well together, however Power Query is not exclusive to Power Pivot though, as it may be used with ordinary PivotTables. There is a good reason for doing this too...

This week I look at combining several Power Query functions in order to standardise some incoming data...

The scenario is familiar, a huge Excel table comes in with lots of columns and rows, but in some cases a column or row is empty and it needs to be condensed...

A huge Excel table comes in with lots of columns and rows, but in some cases a column or row is completely empty, and the table needs to be condensed...

Sometimes, I am happily working away in Power Query when I hit a problem. Features are not there when I need them, something I’m sure should have worked doesn’t...

Since I have reached the milestone of my 50th issue, I have covered a whole list of Power Query features. Talking of lists… (it’s an ellipsis, get it?)