Gilbert Quevauvilliers gets the last word:
Power query can be so powerful and once again it came to my rescue.
I had a requirement where I wanted to append some text to the end of each of the column names in my table.
To do this I did the following below.
Click through for the solution.