How to Clean and Combine Messy Data in Power Query Using a Custom Function

In this video, I walk through how to clean and combine some messy detailed time entry Excel files using a custom function. Normally, you would use a Transform File folder to accomplish this, but I show you have you don't even need the Transform File folder!