Clean data headers with Excel and Power Query

Hi, in this post, we are using Excel transpose function and Power Query to clean up our data headers to the format that we want. For this case, I will replace all ‘-‘ with ‘_’ , remove spaces, and replace ‘&’ with the word ‘And’.

You can use this method to replace any word with another word, trim and remove spaces etc. Hope you guys will find this useful. Refer to my YouTube video below. Thanks 🙂