Power Query - Create a "Super" TRIM Function (plus cool trick)

Learn, step-by-step, how to remove leading, trailing, and internal redundant spaces from text using Power Query. Also, learn the process for converting a query into a reusable, custom function that can be applied to individual columns in a table or to the entire table with a simple table transformation trick. File Download Link: https://www.bcti.com//wp-content/YT_D... 00:49 Using Power Query's TRIM Function 02:10 Overview of the Project Objectives 02:52 Overview of the Needed Functions 03:16 Split Text by Spaces 04:33 Replace Empties with NULLs 06:22 Filtering Out the NULLs 07:20 Combine the Remaining Text 08:14 Creating a Single-Step Solution 10:50 Creating a Reusable Function 14:50 Reusing the Function 15:31 Applying a Function to an Entire Table 16:38 Project Wrapup