Data cleaning is a creative process. It tickles our imagination and makes us find the most interesting solutions for the data issues that we encounter. In this video I will show you 5 easy and interesting data cleaning techniques that will serve you good in your data cleaning journey in Power Query.
🕓TIMESTAMPS:
00:00 Introduction
00:48 Presenting the messy data
02:07 Merging columns
03:51 Using index columns
04:36 Creating custom column with "IF" condition
06:52 Use "Change type" to clean the data
08:27 Lifting UP rows from a column by 1 position
10:18 Mathematical operations with standard and custom columns
13:01 Outro
📚FOLLOW ALONG! LINK WITH THE WORKBOOK:
[ Ссылка ]
💻RELATED VIDEOS:
- Playlist with all my videos on Power Query: [ Ссылка ]
