I was working with a table with quite a few columns where the column names were using Camel Case Notation (ThisIsMyColumnName), and I did not want to rename them manually.

I used the following Power Query Code below to let it do the column renaming and putting in the space for me.

Thanks to @Excel_City for assisting me in finding the answer


This is what my table looked like with the Camel Case Notation

I then added the following code below

The only thing that I changed between different tables was the Previous Step Name, which in my example above was called #”Previous Step Name”

After putting in this step it allowed me to have my column names with the spaces as shown below.

That makes my life a lot easier and working much more efficiently.

Here is a working example of the entire code below.

As always if there are any questions or suggestions please let me know.