Welcome to our Power Query blog. This week, I filter and expand the data in the two Access databases from last week.

Welcome to our Power Query blog. This week, I look at how to access two Access databases.

Welcome to our Power Query blog. This week, I complete the query to look for data in the current workbook.

Welcome to our Power Query blog. This week, I start to convert the query to look for data in the current workbook.

Welcome to our Power Query blog. This week, I copy a query to the workbook data has been extracted from.

Welcome to our Power Query blog. This week, I refine my grouping and show how to preserve data order while grouping.

Welcome to our Power Query blog. This week, I group my data.

Welcome to our Power Query blog. This week, I amend my merge to filter my data.

Welcome to our Power Query blog. This week, I reorganise the data from my appended queries.

Welcome to our Power Query blog. This week, I append queries to extend my data.