Data Cleaning

If you’ve ever worked with text strings in Excel, you may have come across hidden characters that make it difficult to work with the data. These special characters can be a nuisance when you’re trying to manipulate the text, but fortunately, they can be removed with the help of Power Query. Before we begin, it’s … Read more

From time to time, you may find yourself in a situation where you need to find duplicates in Numbers. For instance, you have a list of fruits in one column and the number of each of them in the other, but there are multiples of some of the fruits. It can be tedious to comb … Read more