Excel Power Query Introduction
What is Power Query? This is what Microsoft says: “Power Query is a data transformation and data preparation […]
Series: Excel Power Query
Excel Power Query on YouTube
There are a lot of Excel Power Query tutorials on YouTube. Below is just a short list of […]
Excel Power Query Fill Down
Are you using Power Query to import data into Excel and finding that one of your columns is […]
Excel Power Query Data Type Error
Sometimes when you bring in data into the Power Query Editor, you experience data type errors. Here below […]
Unpivot in Power Query
What is unpivot and when would you use it? The unpivot operation converts columns to rows. It creates […]
Excel Pivot and Unpivot
Many of the transformations in Power Query are fairly easy to grasp but other ones, such as Pivotting […]
Remove Duplicates
In Power Query it is easy to remove duplicates. There is however something to be aware of. Power […]