Power Query Blogs

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.