How to UnPivot Excel Data | Power Query Tips in Tamil | Prabas MS Office

How to unpivot a set of data in excel using Power Query. This video explains the simple concept of unpivoting a consolidated data into raw data using Power Query.

Make sure to download and use the practice file from the following path for better understanding : https://prabastech.com/downloadable-e...

#Unpivot
#PowerQuery
#ExcelTips

00:00 - Introduction
00:33 - What is unpivot in excel
05:00 - Manually Unpivoting Excel Data
06:30 - Auto Unpivoting Excel Data using Power Query
09:00 - Summary of the video

Join us to show your love and support:    / @prabasmsoffice  
   • Announcement for the Join button -  S...  

All Videos of Prabas Microsoft Office in Tamil – தமிழ்:    • Unity of SumProduct, Sumifs, Countifs...  

Diploma in #Computer Application, #Online and #Offline #Microsoft office #Training in #Tamil for #Free, Prabas MS Office, #Prabasmsoffice, PrabasTech.com, #Prabastech, Prabas #excel #word #powerpoint videos, Excel Free downloadable practice file, Latest Excel Training in Tamil, Step by step Excel Training in Tamil, Advanced Microsoft Office Training Center in Chennai, Tamil Nadu, Learn #Office365 in Tamil, Excel #VBA in Tamil, Advanced Excel Training in Chennai, Excel Coaching in Tamil, Free Online Excel Training, Excel Advanced Formulas in Tamil, Excel for Beginner in Tamil, Excel Advanced Training in Tamil, Excel Array Function in Tamil, Excel Pivot Table in Tamil, Excel Basics in Tamil, Excel Tips and Tricks in Tamil, Excel Top Secret in Tamil, Excel Step by Step Guide in Tamil, Latest Excel Ideas, Free Excel Practice Files, Excel Support for Business Problems, Advanced #PowerPoint Training in Chennai, PowerPoint Tamil, PowerPoint Coaching in Tamil, Free Online PowerPoint Training, Microsoft PowerPoint Online Free Training in Tamil, Advanced MS Word Training in Chennai