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?)

This week I look at bringing in two tables of data and summarising some of that data. At the same time..

It’s time to move on...

Welcome to our Power Query blog. This week I look at the options available to organise queries within a workbook.

Welcome to our Power Query blog. This week let's look at how to convert names into an alternative format.

Sometimes, the tasks I have to do are less than thrilling...