Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Join or List – Part 2

7 December 2022

Welcome to our Power Query blog. This week, I continue comparing alternative approaches to extracting data from another table.


Power Query: Join or List – Part 1

30 November 2022

Welcome to our Power Query blog. This week, I begin a series of blogs comparing alternative approaches to extracting data from another table.


Power Query: Flexible Appending – Part 4

23 November 2022

Welcome to our Power Query blog. This week, I explain how to change data types dynamically.


Power Query: Flexible Appending – Part 3

16 November 2022

Welcome to our Power Query blog. This week, I am continuing to combine data from a folder and to use a translation table to create column names.


Power Query: Flexible Appending – Part 2

9 November 2022

Welcome to our Power Query blog. This week, I am continuing to combine data from a folder and to use a translation table to create column names.


Power Query: Flexible Appending – Part 1

2 November 2022

Welcome to our Power Query blog. This week, I am combining data from a folder and using a translation table to create column names.


Power Query: Get Pasted – Part 2

26 October 2022

Welcome to our Power Query blog. This week, after using an alternative approach to a one-off data grab from the web, I transform the data I have pasted.


Power Query: Get Pasted – Part 1

19 October 2022

Welcome to our Power Query blog. This week, we present an alternative approach to a one-off data grab from the web.


Power Query: For Instance, Edit Two Queries

12 October 2022

Welcome to our Power Query blog. This week, we present a cool tip we recently learned to access Power Query in more than one Excel workbook simultaneously.


Power Query: Steps to Take – Part 4

5 October 2022

Welcome to our Power Query blog. This week, I continue with my worked example by unpivoting and combining my data.


Newsletter