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
Bookmarks