M, the Mashup language is very powerful and can be easy to use and modify. Allison shows how you can add a snippet of code to your Advanced Editor in Power Query and what else to modify in the existing code in order to get spaces in your column headers.
Power Query Pattern – Adding Spaces in Text within your data with Camel Case
In this week’s blog post, I created this Power Query Pattern, which I created to add in spaces for CamelCase text within a column. To get this to work for you, all that you do is need to make one change to the code.
Below is what the data looked like