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:
https://www.dropbox.com/scl/fo/7y1m77...

RELATED VIDEOS:
Playlist with all my videos on Power Query:    • Power Query