Power Query - Adding spaces to CamelCase & number fields with List Accumulate

🚀 Unlock the Power of Data Transformation! | Power Query Tutorial 🛠️

Dive into the magic of Power Query with our latest tutorial! 🌟 Learn how to effortlessly add spaces to camelCase and number fields using the powerful List.Accumulate function. 📊 Whether you're a data enthusiast, analyst, or just curious about data manipulation, this video is your key to unlocking new possibilities. ✨

#PowerQuery #DataTransformation #ExcelTips #DataAnalysis #Tutorial #powerbi #excel

Link to File

[odallamico]

Excellent solution. The List.Accumulate function is not very easy, but is important to know it. Thank for sharing

[kebincui]

Your advanced tips on power query are always always excellent. Thanks James ❤👍

[whizzohk]

Thank you Sensei! Another great video on List.Accumulate. I have used this function in several real-world queries since you recently demonstrated its power and flexibility.

[AnilKumar-vioe]

Bang on, you are an artist man.... Learning in depth about power query from your videos....Keep bringing these awesome videos

[ftmagicart]

Great video. Your technique is amazing. Thank you

[eduardomunoz]

wonderful, thank you very much. Greetings

[jerrydellasala]

Great video, but wish you had posted the M Code or put it in a Note in the file. It took me an HOUR to finally see I had state & {" " & CurrentChar} instead of state & {" ", CurrentChar}! 🤪🤪
Would love to see a video on converting this to a function!

[roywilson]

Thanks for the video.l I hated List.Accumulate the first few times I had to use it, kI couldn't get my head around the idea of iteration without some kind of for statement, my brain refused completely to process how the function could possibly keep count of hte number of iterations completed and after that sank in I had real problems seeing how the loop could end. I still find it makes my head ache writing the functions and debugging them is even worse!

[kkaurkify]

Thank you. Your teachings always open up a lot of new knowledge, how and what can be done.
Also, I have a question. Does the file on github also have the code. There is no way I can see it.