Advanced Pivot and Utility of Index Column in Power Query (2 Methods)
In this video I have discussed some cool tips and tricks which you can use to clean up your messy data in few steps and get your desired result.
We have discussed how we can optimally utilize Index Column to our advantage and also about Advanced Pivot tricks.
(00:00 - 02:40) - The Problem
(02:41 - 24:30) - Method One of cleaning the data
(24:31 - 34:06) - Method Two
Stay tuned for more content !!
