OK, I have column names in a Data Warehouse as data source, which do not have spaces in.
i.e.
First_Name
Last_Name
Some_Date
Some_Other_Date
Amount_Number_One_But_Before_Two
Amount
This data is pulled into Power Query where I would like to replace the _ with a space.
i.e.
First Name
Last Name
Some Date
Some Other Date
Amount Number One But Before Two
Instead of manually changing, is there another way?, say M Code to do this?.
The code should work for not just the example above but for any data pull in future.
There could be more columns than the example above, and the column names will have varying number of _ to replace.
Hope that makes sense and is possible.
Many Thanks,