Currently, Power Query identifies duplicates with the value 2 in the Find Duplicates column and displays all duplicates. However, if you scroll to the right, you can see that the Index column is ...

Then, we’ll add an index column, so you can visually see which products belong to the same order. Next, we’ll create the new rows using a delimiter query. A delimiter is a constant character ...

A few weeks ago I wrote a post about comparing the contents of entire tables in Power Query, and a question came up in the comments about how you might go about comparing values in columns rather than ...

Learn 3 powerful methods to unstack data in Power Query. Save time, improve accuracy, and transform messy data into clean, ... Add an index column to assign a unique identifier to each row.

I’ve just learned some really interesting new Power Query/M optimisation tricks! I’m going to write them up here as a series of worked examples rather than generalised patterns because I’m still ...

Simon Hurst looks at conditional columns and the Power Query equivalent of the well-known IF() function. IF() is one of the most frequently used Excel functions.