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 readingFor 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 readingIf 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 readingExcel 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 readingKeep 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 readingRemove 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 readingDuplicate 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