If you want to repeat rows in your dataset N number of times (say 5 or 7 times), or based on a value in a column, Power Query is the easiest way to do that. In this article, I’ll walk you through two methods to repeating all rows the same number of times, and repeating …
I was recently working on a project where I had multiple lists in Excel and I had to create all the possible combinations using these lists. To give you an example, suppose I three separate lists where I have: Now I want to get one single list that would include all the possible combinations from …
Excel is an amazing tool to store and analyze data. And many of the times, you will have to deal with text data types such as names, regions, departments, or product names. In such cases, it’s good to know how to manipulate text data and get the desired result. One of the most common tasks …
Watch Video – Fill Down in Excel A lot of times, you may encounter a data set where only one cell is filled with data and the cells below it are blank till the next value. Something as shown below: While this format works for some people, the problem with this sort of data is …
Running total (also called cumulative sum) is quite commonly used in many situations. It’s a metric that tells you what’s the sum of the values so far. For example, if you have the monthly sales data, then a running total would tell you how much sales have been done till a specific day from the …
Excel allows you to format dates in many different ways. You can choose to show the date in a short date format or in a long date format. You can also only show the day number, the month name, or the year from a given date. In this short Excel tutorial, I will show you …
With Power Query, working with data dispersed across worksheets or even workbooks has become easier. One of the things where Power Query can save you a lot of time is when you have to merge tables with different sizes and columns based on a matching column. Below is a video where I show exactly how …
I recently got a question from a reader about combining multiple worksheets in the same workbook into one single worksheet. I asked him to use Power Query to combine different sheets, but then I realized that for someone new to Power Query, doing this can be tough. So I decided to write this tutorial and …
In this tutorial, I’ll show you how to unpivot data using Power Query (Get & Transform). Pivot Table needs the data in a specific format so that it can analyze it and create different views from it. In case you don’t have the data in a Pivot Table ready format, you can use Power Query to unpivot the data set.
©trumpexcel.com – Free Online Excel Training
