Power Query - Dynamically transform column names

🚀 Unlock the Power of Power Query: Dynamic Spaces, Unpivot Magic, and Clean Sheets! 🚀

Welcome to our latest tutorial where we dive deep into the transformative world of Power Query! If you've ever struggled with camel case column names, wished for a seamless way to unpivot datasets, or needed a magic wand to remove those pesky junk rows from various sheets, this video is your new best friend. 🌟

🔍 What You'll Learn:

Dynamic Camel Case Solution: Learn how to automatically add spaces to camel case column names, making your data more readable and easier to understand. Say goodbye to squinting! 👀
Unpivot Wizardry: Discover how to unpivot your dataset with ease, transforming your data into a format that's perfect for analysis. It's like seeing your data in 3D! 📊
Junk Row Exorcism: We'll share a powerful function that cleans out unwanted rows from various sheets, leaving you with nothing but the pristine data you need. Clean sheets, clear mind! 🧹

#dataanalytics #datacleaning #powerbi #powerquery #mquery #excel

Links:
Solution file

source file

Noteworthy techniques
- nested lets
- custom function
- splitter a..z

Table.Skip

Table.Transpose

Table.TransformColumns

Splitter.SplitTextByCharacterTransition

Table.UnpivotOtherColumns

[seczybb]

Man! You are really Cool! Thanks a lot!!!

[raulparra]

Se aprende mucho con sus videos. Gracias por compartir

[jerrydellasala]

I only found your channel recently and immediately subscribed! Beautiful technique for fixing the column headers.
I understand how to change a regular query into a function, but I once saw a video where the query was set up in such a way that you could right click on it in the PQ editor and select Create Function, and the function was created keeping the source query and in such a way that if the source query was changed, the function created from that query was updated. It would be awesome if you could show that! Maybe then I'd remember where it came from - the way the function used to import files in a folder is created from a regular query which when edited changes in the query are duplicated in the function!
Regardless, great video.

[babbalena]

I hear only left audio from the headphones. Thanks anyway for the video ☺️

[larmondoflairallen]

I had no idea you can invoke a function like that.