Smantin Data

This article will show you how to find and replace values in Power Query that start with a certain value of your choice. Here is an example table with references that should all begin with ‘A0’. However, some values are missing the ‘A’. Therefore we want to find and replace all values that begin with … Read more

Do you have null values in your Power Query table that you want to find and replace with more useful data? In this article we go through how to: These methods will show you how to find and replace nulls without having to add a custom column, which can add unnecessary complications to your data. … Read more

In this article, we will show you how to replace values in multiple columns in Power Query using two different methods. Method 1 is best if you want to replace one value in multiple columns. Method 2 is best if you want to replace multiple values in multiple columns. Method 1: Select multiple columns and … Read more

In this article we will show you two methods for finding and replacing multiple values in Power Query, depending on your data and circumstances. The first method we share can find and replace values in one step using an IF statement. The second method uses a separate query and a custom column with List.Accumulate to … Read more