Rename column names in query as per sheet name

[jeongkim]

Can we rename the column names as per sheet name?

e.g. if sheet name starts 2024 then one of columns to be 2024 blabla,

if sheet name starts 2025 then to be 2025 babla,

Since I renamed manually for all columns to add year number 2024 as data source has very old format which has many of empty column names. 

But the thing is year will change and 2024 should be 2025 next year.

Or, as per one of cell name which is always locatetd there starting with year number like below 

So if I could take '2024' from column 13 cell in red circle, then I can make custom column pasting '2024' for all rows and this can be combined with Q1_QTY, Q2_QTY... then no need to rename them with particualr year number. 

[v-kongfanf-msft]

Hi @jeongkim ,

Can you provide relevant screenshots describing your desired outcome? Is it something like using dynamically selected columns in power query as mentioned in the solution below?

powerbi - Power BI / query, select columns dynamically - Stack Overflow

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly