Checkout this introductory series detailing data cleanup workflows with the Power Query in MS Excel.
Video 1: Introduction to Data Query
– Standardize text formatting on select columns
– Remove duplicate entries
Video 2: Formatting Phone Numbers
– How to remove unwanted characters
– How clean ‘null’ entries
– How to split a column by character count
– How to create a custom column with a formula that formats the phone number as (xxx) xxx-xxxx
Video 3 – Text Extraction with Conditional Columns
– How to create a Conditional Column
– Navigating the IF statement to set condition
Birr-Data 