How to Use First Row as Headers Using Power Query?
For this tutorial, I have the following set of data that is given below. Currently, the headers are not meaningful to me because it is written as Column1, Column2, Column3 so…
Continue readingWe found 0 resources for you...
How to Split Column by Number of Characters Using Power Query?
If you have columns that you need to split by an equal number of characters, say ID numbers then it will be helpful for you. Previously in Power Query: How to Replicate…
Continue readingHow to Replicate Excel’s FIND Function with M in Power Query?
Excel has so many formulas but only a few of them can be used in M. For instance, Excel’s FIND formula to find a specific character in the text will…
Continue readingHow to Keep Duplicate Records Using Power Query?
Keep Duplicate Records Using Power Query From Excel 2016 has a new set of features known as Get & Transform which was known as Power Query in Excel version 2010….
Continue readingHow to Remove Columns Using Power Query?
Remove Columns Using Power Query or Get & Transform Excel in 2016 has a new set of features known as Get & Transform which was known as Power Query in…
Continue readingHow to Duplicate Columns Using Power Query or Get & Transform?
Duplicate Columns Using Power Query Excel in 2016 has a new set of features known as Get & Transform or in earlier versions it is known as Power Query. It…
Continue reading
Page 1 of 4
Next