Here are the steps to define how can we convert our data in table format.

So, let’s break the suspense and understand “Unpivot Table” in Power Query.Ĭonvert the database in Table format first otherwise “Unpivot Table” features would not work. This is the free Add-Ins, we can download it by clicking on this link Download Power Query if we are using Ms-office 2013 but if we are using Ms-Office 2016 then there Is no need to download it. Microsoft Power query has been introduced by Microsoft earlier. Therefore, we would like to update you a super powerful function in Power Query is called “Unpivot Table”. As we did promise to all that we will make you, champion in Excel. Can we do it with the pivot table? Can we do it with simply using option transpose? we don’t think so then should we do it manually copy and paste? manually copy and paste is old style. However, we want to make this report in this below-mentioned screenshot. This data we get from a training B school and this report are about, Date wise teacher’s class schedule in the city. Let’s take an example, just have a look at this screenshot below, this is not a pivot table. However, we know that the pivot table has its own limitation and we know that, when we want to do the analysis of any data, we need to convert data into a pivot table format, so that we just drag the heading with mouse and drop it on a proper place, to get the actual report. When we think of the analysis of data into excel, what comes first in our mind? Yes! The correct answer is the Pivot table.

Power query in excel 2016