Welcome to our Power Query blog. This week, I look at how to remove a random number of rows before useful data.

Welcome to our Power Query blog. This week, I look at how to view the errors for each row.

Welcome to our Power Query blog. This week, I look at the differences in the way that the ‘Standard’ button works on the ‘Transform’ and ‘Add Column’ tabs.

Welcome to our Power Query blog. This week, I look at merging columns to show that not all ‘Merge Columns’ options are born equal.

Welcome to our Power Query blog. This week, I look at whether to append or merge when combining data.

Welcome to our Power Query blog. This week, I look at creating a bridge table.

Welcome to our Power Query blog. This week, I look at how M and culture can go together.

Welcome to our Power Query blog. This week, I look at how text output can be presented.

Welcome to our Power Query blog. This week, I look at how to fill in rows when there is a gap in dates.

Welcome to our Power Query blog. This week, I look at how to calculate a group share.