I this blog post, I will explain the Fill Up and Fill Down Transformation steps in Power Query of Excel with a simple example. Following is the collection report of Infinity Saga which comprises of 23 Marvel movies that were released in 3 Phases. I want to create two reports from this data. 1. Phase-wise…
Whenever, I had to reverse text in Excel, I used to create an user defined function using STRREVERSE function in VBA. But after when I started using Power Query, I found an alternative to the VBA method. Let’s see how to reverse text strings in Excel using Power Query. Following is the list of Names…
Text to Multiple Rows using Power Query in Excel
Extract Number and Text from Alphanumeric Data using Power Query in Excel
Normalized Data using Power Query in Excel
Merge worksheets using Power Query in Excel
