Welcome to our Power Query blog. This week, I look at how to combine rows of similar data.

Welcome to our Power Query blog. This week, I complete the task to simplify the way that I combine the file types into one result.

Welcome to our Power Query blog. This week, I continue to simplify the way that I combine the file types into one result.

Welcome to our Power Query blog. This week, I begin to simplify the way that I combine the file types into one result.

Welcome to our Power Query blog. This week, I look at how I can convert a parameter extracted from the workbook into a Power Query parameter.

Welcome to our Power Query blog. This week, I examine the difference between the types of parameters I have been using.

Welcome to our Power Query blog. This week, I extract the parameters from the Excel workbook.

Welcome to our Power Query blog. This week, I fix a problem that occurs if not all file types exist.

Welcome to our Power Query blog. This week, I create parameters for the filtering process.

Welcome to our Power Query blog. This week, I test the query I have created by changing and adding data.