Power query change column names

[Steveapa]

Hi All.

I have a power query querying a server. I am getting billing$ by year. I pivoted the year column. How can I "M Function" the column names from "2017" to "Bill$ 2017". There are a thousands of projects. Something that will do "for each column, concatenate "Bill $" to the front of current column name

current:
project 2017 2018 2019 2020
abc $500 $600 $700 $800

Future:
project Bill$ 2017 Bill$ 2018 Bill$ 2019 Bill$ 2020
abc $500 $600 $700 $800


Thanks.
Steve
Harrisburg, PA

[alansidman]

Right click on the column and select rename

[Steveapa]

I want to do it programatically... the year values may be different for different runs. something that will do "for each column, concatenate "Bill $" to the front of current column name

[Steveapa]

I created a work around... I am doing a pivot column to make a cross tab. So, to fix this, I am just concatenating "Bill$" to the Year before I pivot the column.

Solved.

Thanks.