Рет қаралды 1,450
#excel #powerquery #datacleanup
Learn how to clean up data quickly. Common problem.
Tabular data has some intermittent merged rows.
Cleaning these manually is time consuming and efficient.
Using Power Query this can be done instantly.
Next time data changes, just refresh.
Download sample file and follow along
efficiency365....
00:51 - Create Table
01:11 - Open with Power Query
01:54 - Create a separate Category column
02:56 - Fill gaps in Category column
03:07 - Remove unwanted rows
03:35 - Check data types
04:17 - Import Data
04:46 - Add more data - refresh
05:04 - Summary
Related videos
11 Rules for clean data - • 11 rules for clean dat...
Multiple headers data clean up - • Multiple header crosst...
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
s.efficiency36...
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
hi.switchy.io/mms
Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - s.efficiency36...
Excel to Power BI - swiy.io/uxlpbi
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: efficiency365....
LinkedIn : / nitinparanjape
Twitter : / drnitinp
Production
--------------------
Music and Effects: elements.envat...
Created using Adobe Premiere: www.adobe.com/...
AI based captions: videoindexer.ai (Microsoft service)