The draft of my book is almost ready (I even have few Excel formulas that are showing me, that I have already wrote 93% of the books, and a total of 359 draft...
Converting column types, and merging columns are common transformations in Power Query. It is so easy to perform these transformations through the Query...
Recently I shared a Matrix Multiplication Power Query technique here, and explained how to use List.Generate as the core step of the multiplication. It was...
In my last Thank You post, I suggested that Matrix multiplication is not Excel's forte. Following that post, I got a cool Power Query solution from Imke...