Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

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.


Power Query: Steps to Take – Part 3

28 September 2022

Welcome to our Power Query blog. This week, I continue with my worked example by transforming dates.


Power Query: Steps to Take – Part 2

21 September 2022

Welcome to our Power Query blog. This week, I continue with my worked example by looking at dates.


Power Query: Steps to Take – Part 1

14 September 2022

Welcome to our Power Query blog. This week, I am going to look at a worked example.


Power Query: Re-returning to the Folder

7 September 2022

Welcome to our Power Query blog. This week, I revisit extracting from a folder (yet) again, to show another approach.


Power Query: Check the Filters - Part 2

31 August 2022

Welcome to our Power Query blog. This week, I look at how the options on the Transform tab can filter a query, saving both time and steps.


Newsletter