Welcome to our Power Query blog. This week, I look at unpivoting data with multiple headings.

Welcome to our Power Query blog. This week, I look at how to use M metadata functions to create a ToolTip for columns.

Welcome to our Power Query blog. This week, I look at how to get the maximum example I used last week in just one step.

Welcome to our Power Query blog. This week, I look at an example of how to work with maximum values.

Welcome to our Power Query blog. This week, I look at a quick method to set column types.

Welcome to our Power Query blog. This week I look at a method to conditionally replace values efficiently.

Welcome to our Power Query blog. This week, I look at using the ‘if’ statement.

Welcome to our Power Query blog. This week, I look at replacing values in all columns in a table.

Welcome to our Power Query blog. This week, I look at transposing versus unpivoting data.

Welcome to our Power Query blog. This week. I look at data from a sheet made up of a number of tables, with a random amount of data that needs to be excluded.