When you want to apply a minor tweak to the document, it should not take long to Spread out columns transcript. This type of basic activity does not have to demand extra training or running through guides to learn it. With the appropriate document modifying resource, you will not take more time than is necessary for such a swift change. Use DocHub to streamline your modifying process whether you are a skilled user or if it is the first time making use of an online editor service. This tool will take minutes or so to learn how to Spread out columns transcript. The sole thing needed to get more productive with editing is a DocHub profile.
A plain document editor like DocHub will help you optimize the amount of time you need to dedicate to document modifying regardless of your prior experience with this kind of instruments. Make an account now and increase your efficiency immediately with DocHub!
How can we transpose data thats in multiple columns but also has multiple headers like this one, which is more like a reporting type of layout into a tabular data set like this, so that its easy for us to create a pivot table, or do further analysis using formulas? Now I made a previous video on this that shows you how to unpivot your data if you have a single header. This time, lets take a look at a more complex unpivot situation. We also want to do it in a dynamic way though, so that if we end up adding more columns to this, all we need to do is refresh the end report and everything will pull automatically through. Lets get to work. (upbeat music) This video is a part of my ultimate Excel Power Query course, which will take you from beginner to writing your own end function. Link is in the description below. So here we have our customer names, we have article description, and we have a nice report about sales values by month, which are actually recorded as dates and by scenario.