Combine Multiple Worksheets of a Workbook using Power Query in Excel

In this blog post, I am explaining the Power Query Method to combine data from multiple worksheets. If you are a person who deals with data in Multiple Worksheets, You should definitely try this one. Following is the screenshot a workbook which contains 7 worksheets called Violet, Indigo, Green, Blue, Orange, Yellow and Red. These…

Add an Index Column using Power Query

In this blog post, I am explaining an easy method to add a new column to a data set which contains Automatically updating Serial Numbers. Following is the data set to which I want to add a new column of Serial Numbers. To add a column of Automatically Updating Serial Numbers to this data, Select…