 Hello, welcome to SSUnited, so see in this site and this is continuation of Power BI tutorial. So today we are going to see how we can pivot the columns. So in the last videos we have seen with the query editor and how we can edit the rows and how we can edit the columns. After that we have seen how we can replace the values. So today we will see how we can pivot the columns. So this feature is available inside the Power BI desktop in query editor. So here what is our requirement? So as we have seen in our project and what our requirement we just want to get the total amount that is due amount with the product and country wise. So here we can see we are having this product and here we are having countries and this is the total due amount. So we just want to rotate this table and this is the output we are expecting. So go to on Power BI desktop and we will see how we can do this. This is the query editor and as of now we have a lot of columns but we are required to have only three columns. So just remove other columns. So for that we can use the choose column. So we can select this choose column and this time we just want to have only product name and total due. After that we want only country name. Only these three columns are required. So click on OK. So now it looks good. After that we just want to product name in the first and country name in the second and total due is the last one. So this is the input table and we just want to rotate as I told you we just want to rotate this country name into the columns and this amount will be the aggregate values for those countries. So how we can do this? So just select that one and go to on transform ribbon and here we can see we are having the pivot column. So this option is a label over here. So we just need to click on this value column it is asking. So we can say total due is the value column now click on OK. So it will take few seconds and we need to wait. So here as we can see this is the product names and this is the France Australia and this is the null value that is available. After that we are having United Kingdom then we are also having Germany and we are having United States and Canada. So these are the countries and we have rotated this as in the output we were expecting. So this option is available inside the power bank desktop and we can directly use the pivot column and we can rotate the table. So thank you so much for watching this video. If you like this video please subscribe our channel to get many more videos. Don't forget to press the bell icon to get the notification of our newly uploaded videos. Thank you so much.