12 Methods to Clean Data using Power Query in Excel are explained in this video.
(00:00) 1. Remove Duplicates
(03:02) 2. Add an Index Column
(06:35 ) 3. Fill Blank Cells
(09:09) 4. Remove Special Characters
(13:16) 5. Change Letter Cases
(15:31) 6. UnPivot Data
(17:31) 7. Remove Columns
(19:52) 8. Transpose Data
(21:58) 9. Text to Columns
(24:41) 10. Remove Extra Spaces
(29:35) 11. Remove Line Breaks
(31:13) 12. Remove Errors

Books on Excel https://xlncad.com/excelresources/'>https://xlncad.com/excelresources/
Get Office 365 Subscription https://microsoftus.evyy.net/3NE6y
Download my free ebook on Excel Macros http://eepurl.com/gpT0RD
Read my articles on Excel https://xlncad.com/

Disclosure: Some of the links are Affiliate Links! If you buy something through one of those links, you won't pay a penny more, but we will get a small commission, which helps keep the lights on. Thank you for your support!

#PowerQuery #PowerQueryTip #PowerQueryTrick