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 readingImport Data from Text Excel In 2016 has a new set of features known as Get & Transform or in earlier versions, it is known as Power Query. It provides…
Continue readingExcel in 2016 has a new set of features known as Get & Transform or in earlier versions, it is known as Power Query. It provides a platform to perform a series of steps to help you to transform your Excel data.
Continue readingNowadays to import the data from a company’s accounting or sales system in the XML format are a very common thing so, don’t worry it’s very easy to import data from XML right into Power Query or Get & transform.
Continue reading